This cube dimension represents the budget version in General Ledger in Financials and is based on the IFS Applications dimensions DIM_GL_BUDGET_VERSION and DIM_COMPANY. 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 own set of .
| Attribute | Hierarchy | Description |
| Budget Version Code | NO | Represents VERSION_IN_YEAR |
| Budget Version Desc | NO | Represents the DESCRIPTION of each budget |
| Budget Version | NO | Built as BUDGET_YEAR + '- ' + CODE + ' - ' + DESCRIPTION |
| Budget Year- Version Code | NO | Represents the CODE, e.g. <budget year> + '-' + <version in year> |
| Budget Version Code Desc | NO | Built as VERSION_IN_YEAR + ' - ' + DESCRIPTION |
| Budget Vresion Text | NO | Displays text notifications of the budget version |
| Budget Year | NO | Represents BUDGET_YEAR |
| Company | NO | Represents COMPANY + ' - ' + <company name> + ' (' + <currency code> + ')' |
| Company Code | NO | Represents Company Code |
| Default Budget Version | NO | TRUE/FALSE attribute defining whether the budget version is the default budget version |
| Budget Version - Last Loaded | NO | Represent the date and time of the last update of the dimension record |
| BudgetVersionHy | YES | Hierachy defined as "Company " -> "Budget Year" -> "Budget Version" |
| Cube Name |
| GENERAL LEDGER |
| BI Access View | BI Component | Recommended Source Type |
| DIM_GL_BUDGET_VERSION_BI | GENLDI | On Line |
| DIM_COMPANY_BI | GENLDI | On Line |
| ETL Step | File Name of SSIS Package | Table Name |
| E - Stage | 1.1.063 Load IFSAppl_DIM_GL_BUDGET_VERSION_BI.dtsx | IFSAppl_DIM_GL_BUDGET_VERSION_BI |
| T - DW | 2.1.063 Load Dw_DIM_GL_BUDGET_VERSION.dtsx | Dw_DIM_GL_BUDGET_VERSION |
| L - DM | 3.1.063 Load Dm_DIM_GL_BUDGET_VERSION.dtsx | DM_DIM_GL_BUDGET_VERSION |