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 |