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 Date	Not Required
Alt_Dim_Id	Not Required
Alt_Dim_Id_With_Rpd_Id	Not Required
Code	Not Required
Company	The company identity.
Company-Date	Defined as the COMPANY + ' - ' + REPORTING DATE
From Date	Not Required
ID	Not Required
Id_With_Rpd_Id	Not Required
Number Attribute1	Not Required
Number Attribute2	Not Required
Number Attribute3	Not Required
Number Attribute4	Not Required
Number Attribute5	Not Required
Reporting Date	The REPORTING_DATE without a time stamp.
Reporting Date String	The date converted to string according to the format 'YYYY-MM-DD'.
Rpd Id Description	Not Required
Rpd Period	Not Required
Rpd Year	Not Required
Rpd_Id	Not Required
String Attribute1	Not Required
String Attribute2	Not Required
String Attribute3	Not Required
String Attribute4	Not Required
String Attribute5	Not Required
Until Date	Not Required
Year Period Num	Not Required
Year Period Str	Not 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 PERIOD	DIM_BI_TIME	DIM_BI_TIME_BI	DIM_BI_TIME_BI	On Line