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)
IDID
Reporting YearReporting Year
Period From DatePeriod From Date
Reporting PeriodReporting Period as whole number
Period Until DatePeriod Until Date
Reporting QuarterReporting Quarter as whole number
Reporting TertialReporting Tertial as whole number
Reporting Half YearReporting Half Year as whole number
Reporting Year Period TxtReporting Year Period Txt as YYYY-MM
Reporting Period TxtReporting Period Txt
Reporting Quarter TxtReporting Quarter as text Qx
Reporting Half Year TxtReporting 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 PERIODDIM_BI_TIME_FINANCE_PQ_BIDIM_BI_TIME_FINANCE_PQOn Line