This cube dimension represents the accounting periods in Fiancials
is based on the IFS Applications dimension DIM_ACCOUNTING_PERIOD. 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
periods.
| Attribute |
Hierarchy |
Description |
| Acc Period End Date |
NO |
Represents the end date (END_DATE) of an accounting
period |
| Acc Period Start Date |
NO |
Represents the start date (START_DATE) of an accounting
period |
| Accounting Period |
NO |
Key. Represents the CODE of the dimension, i.e. 'YYYYPP'
where YYYY is the accounting year and PP is the accounting period. |
| Accounting Period Desc |
NO |
Represents the DESCRIPTION of an accounting period. |
| Accounting Period No |
NO |
Represents the period part, i.e. ACCOUNTING_PERIOD |
| Accounting Period Status |
NO |
Represents the description of the period status in GL
(PERIOD_STATUS_DESC) -- Only implemented in HR cube-- |
| Accounting Period Period Status IL |
NO |
Represents the descrition of the period status in IL
(PERIOD_STATUS_IL_DESC) -- Only implemented in HR cube-- |
| Accounting Period Type |
NO |
Represents the description of the period type
(PERIOD_TYPE_DESC) |
| Accounting Year |
NO |
Represents the year part, i.e. ACCOUNTING_YEAR |
| Accounting Year Period |
NO |
Represents the CODE of the dimension, i.e. i.e. 'YYYYPP'
where YYYY is the accounting year and PP is the accounting period. |
| Accounting Year Status |
NO |
Represents the description of the year status
(YEAR_STATUS_DESC) -- Only implemented in HR cube-- |
| Company |
NO |
Represents the natural parent COMPANY |
| Consolidated |
NO |
Represents the description of consolidated "flag"
(CONSOLIDATED_DESC) -- Only implemented in HR cube-- |
| AccountingYearHy |
YES |
Hierarchy defined as "Company" -> "Accounting Year" |
| AccountingYear-PeriodHy |
YES |
Hierarchy defined as "Company" -> "Accounting Year" ->
"Accounting Period" |
| AccountingYearPeriodHy |
YES |
Hierarchy defined as "Company" -> "Accounting Year
Period" |