In this post I will describe why you should highly consider to have a calendar dimension table in your reporting layer. I provide my own suggestion on creating the table in Oracle, and lastly I explain why you should pay special attention to ISO week.
Continue reading “Creating a calendar dimension table & importance of ISO Week” →