MSC_DIMENSIONS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
DIMENSION_ID DIMENSION_CODE DIMENSION_NAME DESCRIPTION TREE_STRUCTURE_NAME PLANNING_TABLE_NAME LEVEL_COLUMN_NAME MEMBER_COLUMN_NAME SHOW_ALL_MEMBERS ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT DIM.DIMENSION_ID DIMENSION_ID , DIM.DIMENSION_CODE DIMENSION_CODE , NVL(DIM.USER_SPECIFIED_NAME,DIM.NAME) DIMENSION_NAME , DIM.DESCRIPTION DESCRIPTION , DIM.TREE_STRUCTURE_NAME TREE_STRUCTURE_NAME, 'MSC_DIMENSION_'||DIM.DIMENSION_CODE||'_DYD' PLANNING_TABLE_NAME, DIM.DIMENSION_CODE||'_LEVEL_ID' LEVEL_COLUMN_NAME , DIM.DIMENSION_CODE||'_LVL_MEMBER_ID' MEMBER_COLUMN_NAME , DIM.SHOW_ALL_MEMBERS SHOW_ALL_MEMBERS , DIM.ATTRIBUTE1 ATTRIBUTE1 , DIM.ATTRIBUTE2 ATTRIBUTE2 , DIM.ATTRIBUTE3 ATTRIBUTE3 , DIM.CREATED_BY CREATED_BY , DIM.CREATION_DATE CREATION_DATE , DIM.LAST_UPDATED_BY LAST_UPDATED_BY , DIM.LAST_UPDATE_DATE LAST_UPDATE_DATE , DIM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM MSC_DIMENSIONS_VL DIM