The date calendars have been revamped with several goals in mind:
We have made the following changes:
A "presentation friendly" field would be a month, quarter, year with a text qualifier e.g. Q 2 or FY 2001.
In addition, the new dimension names are prefixed as vd_Cal_ instead of the old vd_CalYr
Here is an example of the old vs new:
We have further segmented calendar dimensions into two camps:
Let's use Vehicle Mileage as an example. Trip End Date is the main driver of the data model, so we can perform drill downs. Trip Start Date is not the main driver - just a field that would augment the big picture.
In some cases a data model might have several "driver" calendar dimensions. For instance Sales has one for transaction dates and one for Open Sales Orders Shipping Date (as well as one each for Service Date and Fully Paid Date).
Our architecture does NOT require that a calendar table be marked as a "date table" in PowerPivot or Power BI.
Example of the Transaction Date Dimension in the Sales Data Model :
Please enable JavaScript to use file uploader.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6173/calendar-dimensions
Your session has expired. You are being logged out.