O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Derived Hierarchies

In our example scenario, as we have stores in many different cities and states, we have a requirement to create a "Stores by Geography" hierarchy. In order to create the hierarchy, carry out the following steps:

  1. Navigate to the System Administration function, which can be accessed using the Master Data Manager home page.
  2. Hover over the Manage menu and click on the Derived Hierarchies menu item, which will open the Derived Hierarchy Maintenance page.
  3. Click on the green plus icon to add a Derived Hierarchy, which will open the Add Derived Hierarchy page.
  4. Enter Stores By Geography as the Derived Hierarchy Name and click on save.
  5. The Edit Derived Hierarchy page will now be displayed, where we can build the hierarchy. On the left-hand ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required