The DWH time slice IDs show different minimum and maximum dates on the Clarity schema vs the min/max dates on the DWH schema (dwh_com_periods table).
from prj_blb_slicerequests sr
where SR.IS_DWH_REQUEST = 1
Why do the end dates do not match? Should they match?
In order get the periods for the DWH, there are other criteria that need to be taken into consideration.
The query to compare on the Clarity schema is:
If you then review the SQL behind this view you will see it looks at items such as fiscal periods (biz_com_periods) and data in rpt_calendar table in addition to the actual DWH slices in the Time Slices page.