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').
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 |
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_ACCOUNT.dtsx | Dm_DIM_ACC_ATTR_ITEM_ACCOUNT |