This cube dimension represents financial Accounting Attributes related to code part B. There is no core dimension aviailable as source. Instead the view ACCOUNTING_ATTRIBUTE_CON is used as source. The view contains all available accounting attributes in any company. During the ETL process a specific Code B attribute dimension is created, DIM_ACC_ATTR_ITEM_CODE_B, i.e. accounting attribute 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 attributes with identity according to Configuration table Acc_Attr_Config where "CODE_PART_TYPE= 'CODE_B' ". This means that to be able to use the Code B Attribute dimension e.g. when browsing the cube, there must exist an accounting attribute 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, ATTRIBUTE, ATTRIBUTE_VALUE and type ('Leaf-CodePartValue', 'Node-AttributeValue' or ' Node-Attribute').
Attribute | Hierarchy | Description |
Code B Attr Value Desc | NO | Represents the description of the attribute value |
Code B Attribute - Last Loaded | NO | Last Loaded date |
Code B Attribute Id | NO | This is the Code B attribute identity. Displayed using attribute description |
Code B Attribute Item | 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 |
CodeBAttrHy | NO | Represents the parent item ITEM_ABOVE_ID, being a parent to Code B Attribute Item. This is an implicit hierarchy. |
Company Code | NO | Represents the company |
Cube Name |
GENERAL LEDGER |
Access Object | BI Component |
ACCOUNTING_ATTRIBUTE_CON | ACCRDI |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.116 Load IFSAppl_ACCOUNTING_ATTRIBUTE_CON.dtsx | IFSAppl_ACCOUNTING_ATTRIBUTE_CON |
T - DW | 2.1.116 Load Dw_ACCOUNTING_ATTRIBUTE_CON.dtsx | Dw_ACCOUNTING_ATTRIBUTE_CON |
L - DM | 3.1.116 Load Dm_DIM_ACC_ATTR_ITEM_CODE_B.dtsx | Dm_DIM_ACC_ATTR_ITEM_CODE_B |