This cube dimension represents project cost structure and is based on the IFS Applications dimension DIM_PROJ_COST_STRUCTURE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural keys are COMPANY, COST_STRUCTURE_ID, NAME_VALUE, PROJ_COST_STRUCT_ITEM_TYPE
Attribute | Hierarchy | Description |
Project Cost Structure Hierarchy | NO | Parent Key. Refers to Parent_Id, a technical key representing the parent Project Cost Structure Node |
Project Cost Structure Node | NO | Key. Defined as the descriotion of the node (NODE_DESCRIPTION) |
Cube Name |
PROJECT |
BI Access View | BI Component | Recommended Source Type |
DIM_PROJ_COST_STRUCTURE_BI | PROJDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.097 Load IFSAppl_DIM_PROJ_COST_STRUCTURE.dtsx | IFSAppl_DIM_PROJ_COST_STRUCTURE |
T - DW | 2.1.097 Load Dw_DIM_PROJ_COST_STRUCTURE.dtsx | Dw_DIM_PROJ_COST_STRUCTURE |
L - DM | 3.1.097 Load Dm_DIM_PROJ_COST_STRUCTURE.dtsx | Dm_DIM_PROJ_COST_STRUCTURE |