Creating hierarchies
Now that you have created and imported a table that contains date information, you need to establish how the data in the MasterCalendar_T table is related. This recipe shows you how to create the standard Year | Quarter | Month | Day hierarchy.
How to do it...
Left-click on the MasterCalendar_T to select the table, then right-click to bring up the menu of options, and select Create Hierarchy.
On the new virtual column that was added to your table, you will add the columns required to build the hierarchy.
Select each column one by one and drag to the Hierarchy1 name. When completed you will see your completed hierarchy.
Next, right-click on Hierarchy1 and then select Rename and change the name to Calendar_YQMD. This identifies the hierarchy as a regular calendar and tells your users what values are available in the hierarchy.
Next, you need to define the sort order of the calendar for the hierarchy. Sort order is set on the property of the base columns. On the Quarter_Name...
