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
Reporting Year Reporting Year
Period From Date Period From Date
Reporting Period Reporting Period as whole number
Period Until Date Period Until Date
Reporting Quarter Reporting Quarter as whole number
Reporting Tertial Reporting Tertial as whole number
Reporting Half Year Reporting Half Year as whole number
Reporting Year Period Txt Reporting Year Period Txt as YYYY-MM
Reporting Period Txt Reporting Period Txt
Reporting Quarter Txt Reporting Quarter as text Qx
Reporting Half Year Txt Reporting Half Year as text Hx

Hierarchies

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

USED BY MODEL(S)

Model Name
CRM
General Ledger
Production Performance

Data source Information

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
REPORTING PERIOD DIM_BI_TIME_FINANCE_PQ_BI DIM_BI_TIME_FINANCE_PQ On Line