HPS_STAR_DIM_Dimension_Name
This table is created for each user-defined dimension in an application.
Table 8. HPS_STAR_DIM_dimension Table Columns
Column | Description |
|---|
CHILD_MEMBER_ID | ID of the member in the CHILD_NAME column. This is a foreign key to dimension_name_ID in HPS_STAR_FACT. |
CHILD_NAME | Name of each member in the dimension prefixed with “dimension_name” |
CHILD_ALIAS | Alias for the member in CHILD_NAME. |
PARENT_NAME | Name of the Parent of the member in CHILD_NAME prefixed with “dimension_name” |