[Home] [Help]
View: EDW_HIERARCHY_LEVEL_MD_V
View Text
SELECT DIM.ELEMENTID
, DIM.NAME
, HIER.ELEMENTID
, HIER.NAME
, CLVL.ELEMENTID
, CLVL.NAME
, CLVL.PREFIX
, LVLREL.PARENTLEVEL
FROM CMPWBDIMENSION_V DIM
, CMPITEMHIERARCHY_V HIER
, CMPLEVELRELATIONSHIP_V LVLREL
, CMPLEVEL_V CLVL
WHERE DIM.ELEMENTID = HIER.OWNDIMENSION
AND HIER.ELEMENTID = LVLREL.HIERARCHY
AND LVLREL.CHILDLEVEL = CLVL.ELEMENTID WITH READ ONLY
Columns
Name |
DIM_ID |
DIM_NAME |
HIER_ID |
HIER_NAME |
LVL_ID |
LVL_NAME |
LVL_PREFIX |
PARENT_LVL_ID |