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.
This is due to a mismatch in the server date time stamp between the Application and Database server.
The time stamp will need to match and sync down to the second in order for the data to populate into the views.
The Server team will need to be engaged to synchronize the time between the two servers.
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.