Model: Project - Specifications for Dimension Table: REPORTING PERIOD

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

Attributes

AttributeDescription (where applicable)
CompanyCompany
Company-DateCompany-Date
Reporting DateReporting Date
Reporting Period DescrReporting Period Definition Description
Reporting Period NoReporting Period Number
Reporting YearReporting Year
Reporting YearPeriodReporting Year Period

Hierarchies

HierarchyLevel
RepPeriodFHy
Company
Reporting Year
Reporting Period No
Reporting Date
Company-Date
RepPeriodSHy
Company
Reporting Year
Reporting Period No

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 TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
REPORTING PERIODDIM_REPORTING_PERIOD_PROJECT_TMDIM_RPD_COMPANY_PERIOD_BIDIM_RPD_COMPANY_PERIODOn Line