This cube dimension represents financial structures related to Code Part B. There is no core dimension aviailable as source. Instead the view ACCOUNTING_STRUCTURE_ITEM is used as source. The view contains node and leaf values for all accounting structures in any company. During the ETL process a specific Code B structure dimension is created, DIM_ACC_STRUCTURE_ITEM_CODE_B, i.e. accounting structure item info related to only code part B but in any company. The DSV definition refers to this dimension but there is a filter criteria that sorts out only structures with identity according to Configuration table Acc_Struct_Config where "CODE_PART_TYPE= 'CODE_B' ". This means that to be able to use the Code B Structure dimension e.g. when browsing the cube, there must exist a structure with an identity according to the above mentioned configuration in companies to be analyzed.
All cubes that refers to this dimension will have the attributes and hierarchies as described below.
A unique identity for a row is defined as COMPANY, STRUCTURE_ID, NAME_VALUE and STRUCTURE_ITEM_TYPE. The NAME_VALUE represents a node or a leaf name/id and the STRUCTURE_ITEM_TYPE is '1' for nodes and '2' for leaves.
Attribute | Hierarchy | Description |
Code B Struct - Last Loaded | NO | Last Loaded date |
Code B Struct Code | NO | This is the key attribute and it has item_id as key, i.e. a key value that either represents a node or a reference to the code B dimension. It is displayed as using the ITEM_DESCR, i.e. the node description or the leaf value |
Code B Structure Id | NO | Code B Structure Identity |
Code B Structure Level | NO | Represents the user defined identity of level in the Code B accounting structure |
CodeBStructHy | NO | Represents the parent item ITEM_ABOVE_ID, being a parent to Code B Struct Code. This is an implicit hierarchy. |
Company Code | NO | Represents the company |
Cube Name |
GENERAL LEDGER |
Access Object | BI Component |
ACCOUNTING_STRUCTURE_ITEM | GENLDI |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.077 Load IFSAppl_ACCOUNTING_STRUCTURE_ITEM_TAB.dtsx | IFSAppl_ACCOUNTING_STRUCTURE_ITEM |
T - DW | 2.1.077 Load Dw_DIM_ACCOUNTING_STRUCTURE_ITEM.dtsx | Dw_DIM_ACCOUNTING_STRUCTURE_ITEM |
L - DM | 3.1.077 Load Dm_DIM_ACC_STRUCTURE_ITEM_CODE_B.dtsx | Dm_DIM_ACC_STRUCTURE_ITEM_CODE_B |