In-memory, the Future - Getting Started with SQL Server 2012 Cube Development - page 297

The next step is to create a hierarchy in the DimDate table. To do this, perform the
following steps:
1. Make sure that you are in Grid view and click on the DimDate tab.
2. Add a new column with the following code:
="HY " & [CalendarSemester]
3. Name the newly created column as Calendar Semester .
4. Add a new column with the following code:
=CONCATENATE("Q", [CalendarQuarter])
5. Name the newly created column Calendar Quarter .
6. Click on the Diagram view and select the DimDate table.
7. Click on the Create Hierarchy button.
8. Rename the hierarchy to Calendar Hierarchy .
9. Drag the CalendarYear column to Calendar Hierarchy .
10. Drag the Calendar Semester column to Calendar Hierarchy and drop it be-
low CalendarYear .