Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 254

ers you need to create two new measures using the fact table column
Customer Key. To create the two new measures follow the steps below.
1. Drag and drop the Customer Key column from the Fact Internet
Sales table in the DSV of the cube editor to the Measures pane.
A measure called Customer Key is now created. In the Proper-
ties pane change the name for this measure from Customer Key
to Distinct Customers by right clicking on the measure selecting
Rename. Change the aggregate function for this measure to be
Distinct Count.
2. Drag and drop the Customer Key column once again from the
DSV to the Measures pane. A measure called Customer Key
is created. Rename the Customer Key to Total Customers and
change the aggregate function from Sum to Count.
3. The Unit Price - Fact Internet Sales of a product is the same
value. Therefore this value should not be aggregated. In order to
see the same value for a specific product you need to choose the
aggregate function FirstNonEmpty.
4. Create a hierarchy called Products in the Dim Product dimension with two
levels Model Name and English Product Name. Rename the level English
Product Name as Product Name.
5. Deploy the project to the Analysis Services instance.
Once the deployment is completed you will be in the Browser tab. When you ex-
pand the Measures folder you will see two folders called DisplayFolder1 and Dis-
playFolder2 that contain the measure Sales Amount as shown in Figure 6-24 . You
might recall that we mentioned you cannot have measures from multiple meas-
ure groups grouped under the same display folder. Display folders specified for
a measure are always expected to be within the scope of the measure group.
However due to minor issue in BIDS Browser you can see that the second display
folder DisplayFolder2 specified for a measure is not under the measure group as
shown in Figure 6-24 . You can in fact specify multiple display folders for a meas-
ure and thereby have measures from various measure groups grouped under the
same display folder. However display folders are expected to be used by client
tools and based on the client tool you are using you might not be able to do this.