CUBE DIMENSION - PLANNING SCENARIO

This cube dimension represents sales person and is based on the IFS Applications dimension PLANNING SCENARIO. All cubes that refer to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Company Code NO Represents the Company Code of the dimension.
Planning Scenario Desc NO Represents the Description of the dimension.
Planning Scenario NO Key. Represented as of COMPANY  + ' - ' + CODE + ' - ' + DESCRIPTION
Planning Scenario Code NO Represents the CODE of the dimension.
Planning Scenario Code Desc NO Combination of CODE + ' - ' + DESCRIPTION
Planning ScenarioHy NO Hierarchy consisting of levels:
-Company Code
-Planning Scenario Code Desc

USED BY CUBE

Cube Name
GENERAL LEDGER

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SCENARIO_BI BUSPDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.166 Load IFSAppl_DIM_SCENARIO_BI.dtsx IFSAppl_DIM_SCENARIO_BI
T - DW 2.1.166 Load Dw_DIM_SCENARIO.dtsx Dw_DIM_SCENARIO
L - DM 3.1.166 Load Dm_DIM_SCENARIO.dtsx Dm_DIM_SCENARIO