This cube dimension represents accounting projects in Financials and is based on the IFS Applications dimension DIM_ACCOUNTING_PROJECT. 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 accounting projects.
| Attribute | Hierarchy | Description |
| Accounting Project | NO | Built as CODE + ' - ' + DESCRIPTION |
| Accounting Project Code | NO | Represents the CODE of the dimension, i.e. accounting projects |
| Accounting Project Desc | NO | Represents the DESCRIPTION of an accounting project |
| Accounting Project Group | NO | Represents the PROJECT_GROUP_DESC, i.e. description of the project group |
| Accounting Project Status | NO | Represents the PROJECT_STATUS_DESC, i.e. description of the project status |
| Accounting Project Type | NO | Represents the PROJECT_TYPE_DESC, i.e. the project type description |
| Company | NO | Represents the natural parent COMPANY |
| AccountingProjectHy | YES | Hierachy defined as "Company" -> "Accounting Project Group" -> "Accounting Project" |
| Cube Name |
| GENERAL LEDGER |
| BI Access View | BI Component | Recommended Source Type |
| DIM_ACCOUNTING_PROJECT_BI | GENLDI | On Line |
| ETL Step/td> | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.061 Load IFSAppl_DIM_ACCOUNTING_PROJECT_BI.dtsx | IFSAppl_DIM_ACCOUNTING_PROJECT_BI |
| T - DW | 2.1.061 Load Dw_DIM_ACCOUNTING_PROJECT.dtsx | Dw_DIM_ACCOUNTING_PROJECT |
| L - DM | 3.1.061 Load Dm_DIM_ACCOUNTING_PROJECT.dtsx | Dm_DIM_ACCOUNTING_PROJECT |