Modifying model hierarchies
Once you have created a hierarchy, you may want to remove or modify the hierarchy from your model. In this recipe, we will make modifications to the Calendar_YQMD hierarchy.
How to do it...
Open Model.bim in the Diagram view and find the Master_Calendar_T table.
Review the Calendar_YQMD hierarchy and included columns.
Select the Quarter_Name column and right-click on it to bring up the menu.
Select Remove from Hierarchy to delete Quarter_Name from the hierarchy and confirm on the next screen by selecting Remove from Hierarchy.
Select the Calendar_YQMD hierarchy and right-click on it and select Rename.
Change the name to Calendar_YMD and hit on Enter.
How it works...
In this recipe, we opened the Diagram view and selected the Master_Calendar_T table to find the existing hierarchy. After selecting the Quarter_Name column in the hierarchy, we used the menus to view the available options for modifications. Then we selected the option to remove the column from the hierarchy...
