Currently, the Properties Group for the Customers dimension is Contact Title. We will add a new Properties Group, City. Recall that City is a level within the Customers hierarchy—individual Customer members aggregate into Cities, which aggregate into Countries. We are going to amend this Hierarchy next, so that there is no aggregation for Cities, only for Countries. Thus, we will proceed with two "modifications" before re-creating the Dimension in the following steps.
Tip
You may in fact use a field for both a Hierarchy and for an Alias or a
Property; in other words, a field need not be used exclusively for one
or the other.
1. From the PowerOLAP ribbon, go to Data tab then in the OLAP Exchange control group select Modify Relational Dimension command.
2. Select a dimension (E.g., Customers), then click on OK.
3. Click OK in the message box to proceed with modifying the Dimension.
4. Click Next successively to reach the Define Properties dialog box.
5. Click on the Add Group button.
Note that Group 2 appears in the Properties drop-down box.
6. Select City in the fields list on the left, then click on the Add to property group icon in the center of the dialog box.
7. Click Next to reach the Define Hierarchy dialog box.
The above procedure covers the steps for changing the properties.
In order to follow this exercise, you will need to proceed to the next topic: 'Change Hierarchy', right after coming into the Define Hierarchy dialog box.
Otherwise, simply click Next until you reach the Relational Dimensional Summary dialog, from where you will need to click Finish to complete applying the changes to properties.