In this example, we will see how a user can create hierarchies in the browser and how a developer can create a predefined hierarchy for business requirements by performing the following steps:
Go to the cube Browser, drag-and-drop Calendar Year, Month, and Date, one after another. Then, drag-and-drop Sales Amount and Order Quantity. You will see a hierarchy created dynamically from the browser.
Now, go to the product's Dimension Designer, drag-and-drop the EnglishProductCategory name into the Attributes pane, and rename it
ProductCategory. Do the same for EnglishProductSubcategoryName and rename itProductSubcategory. Rename the Product Key attributeProductand change its name column to EnglishProductName.Drag-and-drop Product Category from the Attributes pane into the Hierarchies pane.
A new hierarchy will be created; rename it
ProductCategoryHierarchy.Drag-and-drop the product Subcategory under the Product Category option (in the <new level>...