Cube Dimension - Account Attribute

This cube dimension represents financial Accounting Attributes related to Account. 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 Account attribute dimension is created, DIM_ACC_ATTR_ITEM_ACCOUNT, i.e. accounting attribute info related to only Account 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= 'ACCOUNT' ". This means that to be able to use the Account 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
Account Attr Value Desc NO Represents the description of the attribute value
Account Attribute - Last Loaded NO Last Loaded date
Account Attribute Id NO This is the Account attribute identity. Displayed using attribute description
Account 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 Account dimension. It is displayed as using the ITEM_DESCR, i.e. the node description or the leaf value
Account Attribute Value NO Represent the attribute value
AccountAttrHy NO Represents the parent item ITEM_ABOVE_ID, being a parent to Account 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_ACCOUNT.dtsx Dm_DIM_ACC_ATTR_ITEM_ACCOUNT