Model: Revenue Recognition - Specifications for Dimension Table: REPORTING PERIOD

On this page you will find the specifications regarding the Model: Revenue Recognition and Dimension Table: REPORTING PERIOD.

This model dimension represents company reporting periods and is based on the IFS Cloud Parquet dimension DIM_BI_TIME_FINANCE_PQ.

Attributes

Attribute	Description (where applicable)
ID	ID
Period From Date	Period From Date
Period Until Date	Period Until Date
Reporting Half Year	Reporting Half Year as whole number
Reporting Half Year as Text	Reporting Half Year as text Hx
Reporting Period	Reporting Period as whole number
Reporting Period as Text	Reporting Year Period Txt as YYYY-MM
Reporting Quarter	Reporting Quarter as whole number
Reporting Quarter as Text	Reporting Quarter as text Qx
Reporting Tertial	Reporting Tertial as whole number
Reporting Year	Reporting Year
Reporting Year Period Txt	Reporting Year Period Txt as YYYY-MM

Hierarchies

Hierarchy	Level
YearPeriod Hierarchy
	Reporting Year
	Reporting Period
YearPeriodTxt Hierarchy
	Reporting Year
	Reporting Year Period Txt
YearQuarterPeriod Hierarchy
	Reporting Year
	Reporting Quarter as Text
	Reporting Period

USED BY MODEL(S)

Model Name

CRM

General Ledger

Group Consolidation

Incident Analysis

Maintenance

Procurement

Production Performance

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
REPORTING PERIOD	DIM_BI_TIME_BI	DIM_BI_TIME_BI	DIM_BI_TIME	On Line