On this page you will find the specifications regarding the Model: Employee Analysis and Dimension Table: ACCOUNTING PERIOD.
This model dimension represents the accounting periods in Fiancials is based on the IFS Cloud dimension DIM_ACCOUNTING_PERIOD. All models that refer 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 | Description (where applicable) |
| Company | Represents the natural parent COMPANY |
| Accounting Year Period | Represents the CODE of the dimension, i.e. i.e. 'YYYYPP' where YYYY is the accounting year and PP is the accounting period. |
| Accounting Period Desc | Represents the DESCRIPTION of an accounting period. |
| Acc Period Start Date | Represents the start date (START_DATE) of an accountig period. |
| Acc Period End Date | Represents the end date (END_DATE) of an accounting period |
| Accounting Period Type | Represents the description of the period type (PERIOD_TYPE_DESC) |
| Accounting Year | Represents the year part, i.e. ACCOUNTING_YEAR |
| Accounting Period No | Represents the period part, i.e. ACCOUNTING_PERIOD |
| Accounting Period | Represents the CODE of the dimension, i.e. 'YYYYPP' where YYYY is the accounting year and PP is the accounting period. |
| Hierarchy | Level |
| AccountingYear-PeriodHy | |
| Company | |
| Accounting Year | |
| Accounting Period | |
| AccountingYearHy | |
| Company | |
| Accounting Year | |
| AccountingYearPeriodHy | |
| Company | |
| Accounting Year Period |
| Model Name |
| CRM |
| Employee Analysis |
| General Ledger |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| ACCOUNTING PERIOD | DIM_ACCOUNTING_PERIOD_BI | DIM_ACCOUNTING_PERIOD | On Line |