MSC_DIMENSIONS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
DIMENSION_ID DIMENSION_CODE NAME USER_SPECIFIED_NAME DESCRIPTION TREE_STRUCTURE_NAME PLANNING_TABLE_NAME LEVEL_COLUMN_NAME MEMBER_COLUMN_NAME SHOW_ALL_MEMBERS ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 IS_ATTR_DIMENSION IS_END_DMD_DIMENSION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT DIMB.DIMENSION_ID DIMENSION_ID , DIMB.DIMENSION_CODE DIMENSION_CODE , DIMTL.NAME NAME , DIMTL.USER_SPECIFIED_NAME USER_SPECIFIED_NAME, DIMTL.DESCRIPTION DESCRIPTION , DIMB.TREE_STRUCTURE_NAME TREE_STRUCTURE_NAME, 'MSC_DIMENSION_'||DIMB.DIMENSION_CODE||'_DYD' PLANNING_TABLE_NAME, DIMB.DIMENSION_CODE||'_LEVEL_ID' LEVEL_COLUMN_NAME , DIMB.DIMENSION_CODE||'_LVL_MEMBER_ID' MEMBER_COLUMN_NAME , DIMB.SHOW_ALL_MEMBERS SHOW_ALL_MEMBERS , DIMB.ATTRIBUTE1 ATTRIBUTE1 , DIMB.ATTRIBUTE2 ATTRIBUTE2 , DIMB.ATTRIBUTE3 ATTRIBUTE3 , DIMB.IS_ATTR_DIMENSION IS_ATTR_DIMENSION, DIMB.IS_END_DMD_DIMENSION IS_END_DMD_DIMENSION, DIMB.CREATED_BY CREATED_BY , DIMB.CREATION_DATE CREATION_DATE , DIMB.LAST_UPDATED_BY LAST_UPDATED_BY , DIMB.LAST_UPDATE_DATE LAST_UPDATE_DATE , DIMB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM MSC_DIMENSIONS_B DIMB , MSC_DIMENSIONS_TL DIMTL WHERE DIMB.DIMENSION_ID = DIMTL.DIMENSION_ID AND DIMTL.LANGUAGE = USERENV('LANG')