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.
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 |
Cube Name |
GENERAL LEDGER |
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 |