MSC_MSR_DIM_MAP
ODS table to store the mapping details of the dimensions for the measures, where the user maps one or more dimensions of the measure being collected to a non-designated dimension in the CSV file. For example, the 'SOURCE' dimension does not have a designated column in the XLSM template so the user can map source with one of the existing dimensions in CSV.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_MSR_DIM_MAP_PK |
MEASURE_ID, SOURCE_DIMENSION_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| MEASURE_ID | NUMBER | Yes | Identifier of the measure for which a dimension mapping is needed. | |
| SOURCE_DIMENSION_ID | NUMBER | Yes | Identifier of the dimension for which a mapping to a target dimension is needed. | |
| TARGET_DIMENSION_ID | NUMBER | Yes | Identifier of the dimension that should be used in place of a source dimension. | |
| SOURCE_LVL_COLUMN_NAME | VARCHAR2 | 30 | Yes | Name of the level column that needs the mapping with another dimension. |
| TARGET_LVL_COLUMN_NAME | VARCHAR2 | 30 | Yes | Name of the target column that should be used in place of a source dimension. |
| SOURCE_MEMBER_COLUMN_NAME | VARCHAR2 | 30 | Yes | Name of the level member column that needs the mapping with another dimension. |
| TARGET_MEMBER_COLUMN_NAME | VARCHAR2 | 30 | Yes | Name of the target member column that should be used in place of a source dimension. |
| MEASURE_DATA_VIEW_NAME | VARCHAR2 | 30 | Name of the database view used by Rolap Snapshot to read the measure data for the current measure. | |
| MEASURE_LEVEL_VIEW_NAME | VARCHAR2 | 30 | Name of the database view used by Rolap Snapshot to read level data for the current measure. | |
| AGGR_MEASURE_DATA_VIEW_NAME | VARCHAR2 | 30 | Name of the database view used by Rolap Snapshot to read the aggregated measure data for the current measure for the non-key customers. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_MSR_DIM_MAP_U1 | Unique | Default | MEASURE_ID, SOURCE_DIMENSION_ID |