[Home] [Help]
View: EDW_SEC_LVL_INFO_V
View Text
SELECT DIM_ID
, LEVEL_ID
, LEVEL_NAME
, LEVEL_LONG_NAME
, LEVEL_PREFIX||'_NAME' STAR_LEVEL_NAME_COL_NAME
FROM EDW_LEVELS_MD_V LVL
, EDW_ALL_COLUMNS_MD_V COL
WHERE LVL.LEVEL_ID = COL.ENTITY_ID
AND COL.COLUMN_NAME = 'NAME'
Columns
Name |
DIM_ID |
LEVEL_ID |
LEVEL_NAME |
LEVEL_LONG_NAME |
STAR_LEVEL_NAME_COL_NAME |