Model: Employee Analysis - Specifications for Dimension Table: ACCOUNTING PERIOD

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.

Attributes

Attribute	Description (where applicable)
Acc Period End Date	Represents the end date (END_DATE) of an accounting period
Acc Period Start Date	Represents the start date (START_DATE) of an accountig period.
Accounting Period	Represents the CODE of the dimension, 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.
Accounting Period No	Represents the period part, i.e. 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 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.
Company	Represents the natural parent COMPANY

Hierarchies

Hierarchy	Level
AccountingYear-PeriodHy
	Company
	Accounting Year
	Accounting Period
AccountingYearHy
	Company
	Accounting Year
AccountingYearPeriodHy
	Company
	Accounting Year Period

USED BY MODEL(S)

Model Name

Cash Planning

CRM

Employee Analysis

General Ledger

Group Consolidation

Group Reporting

Project

Sales

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
ACCOUNTING PERIOD	DIM_ACCOUNTING_PERIOD_TM	DIM_ACCOUNTING_PERIOD_BI	DIM_ACCOUNTING_PERIOD	On Line