Why do the relative time period dates in the report 'Time Period' parameter show blank values for:
-Current Time Period
-Next Time Period
-Previous Time Period
There are 2 possible reasons why it is not showing.
1.The DWH_LKP_TRANSLATION is missing the needed records to display the relative time periods
2. There is a slice issue.
Once installed, refresh the scheduled job detail page and you should now see the proper values for Previous, Current and Next time periods.
If already installed, perform the following steps:
1. Reslice the time slice ids: 1 and 55555
2. Reset the DWH entity on the Administration > System Options page and click Save.
3. Run the following sequence of jobs:
a. Time Slicing job.
b. Update Report Tables job with all parameters checkmarked
c. Load Datawarehouse job with "Full" parameter checkmarked