Cube Dimension - Code B Attribute

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').

Attributes

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

USED BY CUBE

Cube Name
GENERAL LEDGER

ETL Information

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