After creating our DimTime table in the 1st part of this article, we will now make some improvements on our dimension.
From experience, I would recommend using a key PKDate int type in format yyyymmdd.
This type of key will allow you to get better performance.
This codification in yyyymmdd format should be generalized to all levels of our time axis: year, semester, quarter, month, week ... I therefore suggest that each level (year, semester, quarter, month, week, day) be made up of three distinct attributes:
- --
- Reserve
- Name
Read More Create a Time dimension with SSAS (DimTime) - Part 2