Model: CRM - Specifications for Dimension Table: REPORTING PERIOD

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

Attributes

Attribute Description (where applicable)
Accounting DateNot Required
Alt_Dim_IdNot Required
Alt_Dim_Id_With_Rpd_IdNot Required
CodeNot Required
CompanyThe company identity.
Company-DateDefined as the COMPANY + ' - ' + REPORTING DATE
From DateNot Required
IDNot Required
Id_With_Rpd_IdNot Required
Number Attribute1Not Required
Number Attribute2Not Required
Number Attribute3Not Required
Number Attribute4Not Required
Number Attribute5Not Required
Reporting DateThe REPORTING_DATE without a time stamp.
Reporting Date StringThe date converted to string according to the format 'YYYY-MM-DD'.
Rpd Id DescriptionNot Required
Rpd PeriodNot Required
Rpd YearNot Required
Rpd_IdNot Required
String Attribute1Not Required
String Attribute2Not Required
String Attribute3Not Required
String Attribute4Not Required
String Attribute5Not Required
Until DateNot Required
Year Period NumNot Required
Year Period StrNot Required

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 PERIODDIM_BI_TIMEDIM_BI_TIME_BIDIM_BI_TIME_BIOn Line