Cube Dimension - Code B Structure

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.

Attributes

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

USED BY CUBE

Cube Name
GENERAL LEDGER

ETL Information

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