Property Groups

Next, let's consider the Properties of the Customers dimension, which we assigned earlier through the use of OLAP Exchange^®.

1.   In the 'Customers' Hierarchy dialog box, press the Properties  button on the toolbar .

2.   The Property Groups dialog box appears as in the following figure:

Just as you specified, ContactTitle has been created as the Property Group for the Detailed members of the Customers dimension; thus, the entry in the ContactTitle field (in the underlying database) appears next to the Member as the Property for that Member. For example, the ContactTitle for Alfreds Futterkiste is "Sales Representative"; for Ana Trujillo Emparedados y helados and Antonio Moreno Taqueria it is "Owner" as well—demonstrating that the entries for Properties need not be unique for each Member, as they must for Aliases.

Once again, the Hierarchies (being Country and City) have not had properties assigned to them.

3.   Click OK in the Property Groups dialog box.