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
Product
Category
. Do the same for EnglishProductSubcategoryName and rename itProduct
Subcategory
. Rename the Product Key attributeProduct
and 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
Product
Category
Hierarchy
.Drag-and-drop the product Subcategory under the Product Category option (in the <new level>...