HPS_STAR_MEASURES

The HPS_STAR_MEASURES table enables you to drill down into non-dimensional and composite measures and measure templates. This is a parent-child table. Parent-child relationship are not displayed for dimensional measures.

Table 6. HPS_STAR_MEASURES Table Columns 

Column

Description

MEASURE_ID

Unique, system-generated key for the measure in CHILD_NAME. The MEASURE_ID is referenced in HPS_STAR_FACT .

CHILD_NAME

Name of every non-dimensional child measure.

PARENT_NAME

Depending on the type of generation selected for the database, this information is in PARENT_NAME:

  • If you selected Create with Weights Included to generate the database, this column displays the Perspective ID, if available. Otherwise, the entry in this column displays No perspective.

  • If you selected Create with Measure Hierarchies to generate the database, this column displays the name of the parent measure. The associated non-dimensional child measures that are used in the result formulas of the parent measure are displayed in CHILD_NAME.

    Note:

    A dimensional measure that is used in a result formula will not be displayed.

CHILD_UNIT

Name of the unit for the measure in CHILD_NAME .

CHILD_PTD_FREQ

Frequency with which period-to-date calculations are performed on measure results, such as monthly or weekly.