[Home] [Help]
View: EDW_LEVEL_ATTS_MD_V
View Text
SELECT DIM.ELEMENTID
, DIM.NAME
, LVL.ELEMENTID
, LVL.NAME
, UCOL.ELEMENTID
, UCOL.NAME
, UCOL.LONGNAME
, TO_NUMBER(NULL)
, NULL
FROM CMPWBDIMENSION_V DIM
, CMPLEVEL_V LVL
, CMPRELATIONALDBITEM_V UCOL
WHERE DIM.ELEMENTID = LVL.DIMENSION
AND LVL.ELEMENTID = UCOL.OWNINGRELATION
AND NOT EXISTS ( SELECT 1
FROM CMPUNIQUEKEY_V UK
, CMPWBITEMSETUSAGE_V UKEYCOL
WHERE LVL.ELEMENTID = UK.OWNINGRELATION
AND UK.ELEMENTID = UKEYCOL.ITEMSET
AND UKEYCOL.ATTRIBUTE = UCOL.ELEMENTID ) UNION SELECT DIM.ELEMENTID
, DIM.NAME
, LVL.ELEMENTID
, LVL.NAME
, UCOL.ELEMENTID
, UCOL.NAME
, UCOL.LONGNAME
, UK.ELEMENTID
, UK.NAME
FROM CMPLEVEL_V LVL
, CMPUNIQUEKEY_V UK
, CMPWBITEMSETUSAGE_V UKEYCOL
, CMPRELATIONALDBITEM_V UCOL
, CMPWBDIMENSION_V DIM
WHERE DIM.ELEMENTID = LVL.DIMENSION
AND LVL.ELEMENTID = UCOL.OWNINGRELATION
AND LVL.ELEMENTID = UK.OWNINGRELATION
AND UK.ELEMENTID = UKEYCOL.ITEMSET
AND UKEYCOL.ATTRIBUTE = UCOL.ELEMENTID WITH READ ONLY
Columns
Name |
DIM_ID |
DIM_NAME |
LVL_ID |
LVL_NAME |
LVL_COL_ID |
LVL_COL_NAME |
LVL_COL_LONG_NAME |
UK_ID |
UK_NAME |