[Home] [Help]
View: EDW_SEC_DIM_INFO_V
Product: | BIS - Applications BIS |
Description: | EDW_SEC_DIM_INFO_V |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DIM.DIM_ID DIM_ID
, DIM.DIM_NAME
, DIM.DIM_LONG_NAME
, DIM.DIM_NAME TABLE_NAME
, COLS.COLUMN_NAME LOWEST_LEVEL_COL_NAME
, SUBSTR(DIM.DIM_NAME
, 5
, 30) CONTEXT_NAME
FROM EDW_DIMENSIONS_MD_V DIM
, EDW_UNIQUE_KEYS_MD_V KEYS
, EDW_UNIQUE_KEY_COLUMNS_MD_V COLS
WHERE DIM.DIM_ID = KEYS.ENTITY_ID
AND KEYS.KEY_ID = COLS.KEY_ID
AND KEYS.PRIMARYKEY = 1
Columns
Name |
DIM_ID |
DIM_NAME |
DIM_LONG_NAME |
TABLE_NAME |
LOWEST_LEVEL_COL_NAME |
CONTEXT_NAME |