Time for action – creating a derived hierarchy

In this example, we will create a derived hierarchy from a product category, subcategory, and product. You will learn how to create a hierarchy in WebUI. You will also see how easy it is for an end user to make changes to hierarchies. This will be explored in the following steps:

  1. Open MDS WebUI, and then go to System Administration.
  2. Under the Manage menu, select Derived Hierarchies.
  3. Select PacktPub_BI_Model and add a hierarchy.
  4. Name the hierarchy Product Hierarchy and save it.
  5. In the Edit Derived Hierarchy window, drag-and-drop entities from the Available entities pane into the Current Levels pane in the following order: Product, Product Subcategory, and Product Hierarchy.
  6. After each drag-and-drop action, ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.