CE_CP_DIMENSION_MAPPING
This table stores the mapping of dimension member names that are greater than 80 characters or have Oracle Essbase special characters that are not allowed in dimension member names, to a shortened less than 80 character name without special characters that will be stored in Oracle Essbase cube to satisfy the dimension member name restrictions.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CE_CP_DIMENSION_MAPPING_PK |
ORIGINAL_NAME, DIMENSION_COLUMN_NAME |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ORIGINAL_NAME | VARCHAR2 | 360 | Yes | The name of the original dimension value from the source column. |
| MAPPED_NAME | VARCHAR2 | 80 | Yes | The mapped name of the original value from the source column upto the first 80 characters, excluding any special characters that are not allowed by Oracle Essbase. |
| DIMENSION_COLUMN_NAME | VARCHAR2 | 30 | Yes | The name of the source column represented by the dimension value. |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CE_CP_DIMENSION_MAPPING_U1 | Unique | FUSION_TS_TX_DATA | ORIGINAL_NAME, DIMENSION_COLUMN_NAME |
| CE_CP_DIMENSION_MAPPING_U2 | Unique | FUSION_TS_TX_DATA | MAPPED_NAME, DIMENSION_COLUMN_NAME |