MSC_LEVELS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
LEVEL_ID LEVEL_POS_NUM DIMENSION_ID NAME USER_SPECIFIED_NAME DATA_SOURCE_VIEW ODS_COLUMN_NAME MEMBER_IDENTIFIER USER_KEYCOL1_VALUE USER_KEYCOL2_VALUE USER_KEYCOL3_VALUE BUCKET_TYPE IS_WTM_LEVEL CUSTOM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER IS_END_DMD_LEVEL

Query

SQL_Statement

SELECT LEVEL_ID AS LEVEL_ID , LEVEL_POS_NUM AS LEVEL_POS_NUM , DIMENSION_ID AS DIMENSION_ID , NAME AS NAME , USER_SPECIFIED_NAME AS USER_SPECIFIED_NAME , DATA_SOURCE_VIEW AS DATA_SOURCE_VIEW , ODS_COLUMN_NAME AS ODS_COLUMN_NAME , MEMBER_IDENTIFIER AS MEMBER_IDENTIFIER , USER_KEYCOL1_VALUE AS USER_KEYCOL1_VALUE , USER_KEYCOL2_VALUE AS USER_KEYCOL2_VALUE , USER_KEYCOL3_VALUE AS USER_KEYCOL3_VALUE , BUCKET_TYPE AS BUCKET_TYPE , IS_WTM_LEVEL AS IS_WTM_LEVEL , CUSTOM AS CUSTOM , CREATED_BY AS CREATED_BY , CREATION_DATE AS CREATION_DATE , LAST_UPDATED_BY AS LAST_UPDATED_BY , LAST_UPDATE_DATE AS LAST_UPDATE_DATE , LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN , OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER, IS_END_DMD_LEVEL AS IS_END_DMD_LEVEL FROM ( SELECT ML.LEVEL_ID LEVEL_ID , ML.LEVEL_POS_NUM LEVEL_POS_NUM , ML.DIMENSION_ID DIMENSION_ID , MLT.NAME NAME , MLT.USER_SPECIFIED_NAME USER_SPECIFIED_NAME , ML.DATA_SOURCE_VIEW DATA_SOURCE_VIEW , ML.ODS_COLUMN_NAME ODS_COLUMN_NAME , ML.MEMBER_IDENTIFIER MEMBER_IDENTIFIER , ML.USER_KEYCOL1_VALUE USER_KEYCOL1_VALUE , ML.USER_KEYCOL2_VALUE USER_KEYCOL2_VALUE , ML.USER_KEYCOL3_VALUE USER_KEYCOL3_VALUE , ML.BUCKET_TYPE BUCKET_TYPE , ML.IS_WTM_LEVEL IS_WTM_LEVEL , ML.CUSTOM CUSTOM , ML.CREATED_BY CREATED_BY , ML.CREATION_DATE CREATION_DATE , ML.LAST_UPDATED_BY LAST_UPDATED_BY , ML.LAST_UPDATE_DATE LAST_UPDATE_DATE , ML.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ML.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ML.IS_END_DMD_LEVEL IS_END_DMD_LEVEL FROM MSC_LEVELS_B ML, MSC_LEVELS_TL MLT WHERE ML.LEVEL_ID = MLT.LEVEL_ID AND MLT.LANGUAGE = USERENV('LANG') )