[Home] [Help]
View: EDW_FACT_DIM_RELATIONS_MD_V
View Text
SELECT FACT.ELEMENTID
, FACT.NAME
, FK.ELEMENTID
, FK.NAME
, FCOL.ELEMENTID
, FCOL.NAME
, UCOL.ELEMENTID
, UCOL.NAME
, UK.ELEMENTID
, UK.NAME
, UK.LONGNAME
, DIM.ELEMENTID
, DIM.NAME
, FACT.LONGNAME
FROM CMPWBCUBE_V FACT
, CMPFOREIGNKEY_V FK
, CMPWBITEMSETUSAGE_V FKEYCOL
, CMPRELATIONALDBITEM_V FCOL
, CMPWBITEMSETUSAGE_V UKEYCOL
, CMPRELATIONALDBITEM_V UCOL
, CMPUNIQUEKEY_V UK
, CMPWBDIMENSION_V DIM
WHERE FACT.ELEMENTID = FK.OWNINGRELATION
AND FK.UNIQUEKEY = UK.ELEMENTID
AND UK.OWNINGRELATION = DIM.ELEMENTID
AND FK.ELEMENTID = FKEYCOL.ITEMSET
AND FKEYCOL.ATTRIBUTE = FCOL.ELEMENTID
AND UK.ELEMENTID = UKEYCOL.ITEMSET
AND UKEYCOL.ATTRIBUTE = UCOL.ELEMENTID WITH READ ONLY
Columns
Name |
FACT_ID |
FACT_NAME |
FACT_FK_ID |
FACT_FK_NAME |
FACT_FK_COL_ID |
FACT_FK_COL_NAME |
DIM_UK_COL_ID |
DIM_UK_COL_NAME |
DIM_UK_ID |
DIM_UK_NAME |
DIM_UK_LONG_NAME |
DIM_ID |
DIM_NAME |
FACT_LONG_NAME |