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]

Table: CN_DIM_EXPLOSION_ALL

Product:	CN - Incentive Compensation
Description:	Denormalizes ancestral relationships
Implementation/DBA Data:	CN.CN_DIM_EXPLOSION_ALL

Primary Key: CN_DIM_EXPLOSION_PK

VALUE_ID
ANCESTOR_ID
DIM_HIERARCHY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
CN_DIM_EXPLOSION_ALL		CN_HIERARCHY_NODES_ALL	CN_DIM_EXPLOSION_ALL.VALUE_ID
CN_DIM_EXPLOSION_ALL		CN_HIERARCHY_NODES_ALL	CN_DIM_EXPLOSION_ALL.ANCESTOR_ID