Model: Project - Specifications for Dimension Table: REPORTING PERIOD
Attributes
| Attribute |
Description (where applicable) |
| Company |
Company |
| Company-Date |
Company-Date |
| Reporting Date |
Reporting Date |
| Reporting Period Descr |
Reporting Period Definition Description |
| Reporting Period No |
Reporting Period Number |
| Reporting Year |
Reporting Year |
| Reporting YearPeriod |
Reporting Year Period |
| Hierarchy |
Level |
| RepPeriodFHy |
|
|
Company |
|
Reporting Year |
|
Reporting Period No |
|
Reporting Date |
|
Company-Date |
| RepPeriodSHy |
|
|
Company |
|
Reporting Year |
|
Reporting Period No |
USED BY MODEL(S)
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_REPORTING_PERIOD_PROJECT_TM |
DIM_RPD_COMPANY_PERIOD_BI |
DIM_RPD_COMPANY_PERIOD |
On Line |