HPS_STAR_FACT

The HPS_STAR_FACT table is created in Performance Scorecard to facilitate the export of all data for measures and dimensional measures into Essbase. You can use this table to export large amounts of data, then create reports using the information. Values are calculated and stored in the fact table.

This table is created with a separate row for each instance of a scorecard measure on a scorecard. A daily row is dedicated to a measure’s result, targets and scores, and a null scorecard_id. A daily row is also created for scorecards, showing the score for each target and a null measure_id.

Table 4. HPS STAR_FACT Table Columns

Column

Index

Description

MEASURE_ID

X

ID of each measure.

For dimensional measures, this column contains the Template_ID. If you selected Create with Weights Included this column contains the associated perspective.

INTERSECTION_
ID

X

ID of measures and dimensional measures.

If the measure equals the dimensional measure, the intersection ID is the same as the MEASURE_ID.

SCORECARD_ID

X

ID of each scorecard.

COLLECTED_ RESULT

Measure result. If results are missing, NULL is displayed.

RESULT

Value for a measure used in calculations for a day.

VALUE_DATE

X

Date for which the values are calculated and stored in the fact table.

PTD

Result of the period-to-date calculation. For example, this value could be the sum of results collected for a measure over a specific period of time, such as a year.

WEIGHT

Perspective measure weighting to be used to generate the Star Schema

target

Value of the target on VALUE_DATE.

target_SCORE

Value of score as calculated using target on VALUE_DATE.

target_sub target

 Value of any sub target that you create for a multi-value target

target_sub target_SCORE

 Score of any sub target that you create for a multi-value target

STRATEGY_ID

ID of each strategy element

ACCOUNTABILITY_
ID

ID of each accountability element

status_STATUS

Default or custom status

custom dimension_ID 

ID of any custom dimensions that you created

PTD_RESULTS_SCORE 

Score calculated by a period-to-date function or manually entered.

PTD_RESULTS 

Result calculated by a period-to-date function or manually entered.