This cube dimension represents the financial voucher related account and is based on the IFS Applications dimension DIM_ACCOUNT. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is company, i.e. each company has its on set of account values.
Attribute | Hierarchy | Description |
Account | NO | Built as CODE + ' - ' + DESCRIPTION |
Account Code | NO | Represents the CODE of the dimension, i.e. account |
Account Group | NO | Represents the ACCOUNT_GROUP + ' - ' + ACCOUNT_GROUP_DESC related to an account |
Account Group Code | NO | Represents the ACCOUNT_GROUP for an account |
Account Group Desc | NO | Represents the ACCOUNT_GROUP_DESC related to an account |
Account Type | NO | Represents the ACCOUT_TYPE + ' - ' + ACCOUNT_TYPE_DESC related to an account |
Account Type Code | NO | Represents the ACCOUNT_TYPE related to an account |
Account Type Desc | NO | Represents the ACCOUNT_TYPE_DESC related to an account |
Company | NO | Represents the natural parent COMPANY |
AccountHy | YES | Hierachy defined as "Company" -> "Account" |
AccGroupHy | YES | Hierachy defined as "Company" -> "Account Group" -> "Account" |
AccTypeHy | YES | Hierachy defined as "Company" -> "Account Type" -> "Account" |
Cube Name |
MAINTENENCE |
SALES |
BI Access View | Recommended Source Type |
BI component |
DIM_ACCOUNT_BI | On Line | ACCRDI |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.001 Load IFSAppl_DIM_ACCOUNT_BI.dtsx | IFSAppl_DIM_ACCOUNT_BI |
T - DW | 2.1.001 Load Dw_DIM_ACCOUNT.dtsx | Dw_DIM_ACCOUNT |
L - DM | 3.1.001 Load Dm_DIM_ACCOUNT | Dm_DIM_ACCOUNT |