Missing or incorrect data in Data Warehouse reports.
There are four views in DWH that hold the time period information, deriving the data from DWH_CMN_PERIOD table:
Although the DWH_CMN_PERIOD and RPT_CALENDAR table is being populated, one or all of the tables above are not.
All Clarity Versions
The following views derive data from the DWH_CMN_PERIOD table in the DWH database.
nd the range of their data is determined by the Time Slices defined in the PPM Schema. Following is a table, mapping each view to its corresponding Time Slice type.