[Home] [Help]
View: EDW_LEVEL_ATTS_MD_V
| Product: | BIS - Applications BIS |
|---|
| Description: | EDW_LEVEL_ATTS_MD_V |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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 |