[Assuming that you have proceeded from the previous steps:]
This is in continuation with the previous topic: 'Change Properties'.
For demonstration purposes, we will remove City from the Customers dimension hierarchy.
Now that you have reached the Define Hierarchy dialog box, proceed to the following steps:
1. Expand the hierarchy for the dimension Customers.
2. Select City, then click
on the Remove item icon .png)
in the
center of the dialog box.
Tip
You can make selections in the Fields list on the left as well as the Hierarchy
on the right and place/remove fields through the use of the icons in the
dialog box. Alternately, you can remove all items then begin anew to create
the Dimension hierarchy.
3. Click Next.
As always, the Relational Dimension Summary sums up the parameters of the OLAP Exchange operation and the conversion of the underlying relational table into a PowerOLAP dimension. The detail figure below shows the modifications made to change Aliases, Properties and the Hierarchy.
.png)
4. Click Finish in the Relational Dimension Summary box. A dialog will appear that asks if the template will be saved. Click Yes in the succeeding message box.
5. Click OK in the message box that reports updated points.
Seeing the results in PowerOLAP®
You can now find the new Properties Group, City, and the newly configured Hierarchy, in which Country is the only "parent" Member, from the Customers dimension Hierarchy dialog box.
1. From the PowerOLAP ribbon, go to
Model tab then select the Dimensions
command.
The Dimensions dialog box appears.
2. Select Customers as the dimension and click Edit.
3. Click on the Properties
button, .png)
.
The two following figures bear this out:
.png)
In the figure above, the Property Group City appears in the rightmost column, beside the first Property Group, ContactTitle.
In the figure below, the expanded Mexico Member shows the constituent Members Ana Trujillo Emparedados y helados, Anotono Moreno Taqeria, etc. as children of Mexico (the country)—the City level (previously for these Members, Mexico D.F.) no longer exists. Likewise, Berglunds snabbkop and Folk och fa HB, each of which existed within a City (Lulea and Bracke, respectively) scroll up directly into Sweden.
.png)
4. Close the 'Customers' Hierarchy dialog box to return to the PowerOLAP main application window.