eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BSC_SYS_DIM_LEVEL_RELS_V

Product:	BSC - Balanced Scorecard (Obsolete)
Description:	View of BSC_SYS_DIM_RELS and BSC_SYS_DIM_LEVELS_B.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT LR.DIM_LEVEL_ID
, DL.SHORT_NAME
, DL .SOURCE
, LR.PARENT_DIM_LEVEL_ID
, PL.SHORT_NAME PARENT_SHORT_NAME
, PL.NAME PARENT_NAME
, PL.SOURCE PARENT_SOURCE
, LR.RELATION_COL
FROM BSC_SYS_DIM_LEVEL_RELS LR
, BSC_SYS_DIM_LEVELS_VL DL
, BSC_SYS_DIM_LEVELS_VL PL
WHERE DL.DIM_LEVEL_ID = LR.DIM_LEVEL_ID
AND PL.DIM_LEVEL_ID = LR.PARENT_DIM_LEVEL_ID

Columns

Name
DIM_LEVEL_ID
SHORT_NAME
SOURCE
PARENT_DIM_LEVEL_ID
PARENT_SHORT_NAME
PARENT_NAME
PARENT_SOURCE
RELATION_COL