Screen capture showing the logical CHANNEL dimension mapped to columns in the CHANNEL_DIM table in the GLOBAL schema. The PRIMARY hierarchy has two levels: TOTAL_CHANNEL and CHANNEL.

Mappings for TOTAL_CHANNEL are as follows: Member maps to GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_ID, LONG_DESCRIPTION (American) maps to GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_DSC, LONG_DESCRIPTION (French) maps to GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_DSC_FRENCH, and LONG_DESCRIPTION (Dutch) maps to GLOBAL.CHANNEL_DIM.TOTAL_CHANNEL_DSC_DUTCH.

Mappings for CHANNEL are as follows: Member maps to GLOBAL.CHANNEL_DIM.CHANNEL_ID, LONG_DESCRIPTION (American) maps to GLOBAL.CHANNEL_DIM.CHANNEL_DSC, LONG_DESCRIPTION (French) maps to GLOBAL.CHANNEL_DIM.CHANNEL_DSC_FRENCH, and LONG_DESCRIPTION (Dutch) maps to GLOBAL.CHANNEL_DIM.CHANNEL_DSC_DUTCH.