Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Segregating DISTINCT COUNT
We are returned to the main Analysis Manager console window.
16. Expand the Cubes folder, if necessary, once again.
We see the Customer Sales cube appear, as shown in Figure 30.
Figure 30: The New Customer Sales Cube Appears …
Analysis Manager identifies virtual cubes with the “double” cube icon, as circled in red above.
Verification with MDX
Let’s return to the MDX Sample Application, and resurrect our earlier query to execute it against the new virtual cube, taking the following steps:
1. Start the MDX Sample Application, once again.
2. Click OK at the Connect dialog.
The MDX Sample Application window appears.
3. Ensure that FoodMart 2000 is selected as the database name in the DB box of the toolbar.
4. Select the Customer Sales virtual cube in the Cube drop-down list box.
5. Select File —> Open, and locate and select the query we created and saved as SSP11-1 in the earlier section.
The query appears in the Query pane.
6. Expand Measures –> Measures Level in the Metadata tree, exposing the new Distinct Customers measure (from the DISTINCT_CUSTOMERS standard cube).
The MDX Sample Application – Metadata tree (left section of the Metadata pane) should resemble that partially depicted in Figure 31, complete with the measures from both physical cubes combined in the Customer Sales virtual cube displaying in the Metadata tree (left section of the Metadata pane).
Figure 31: The MDX Sample Application Window (Compressed View)
We will make a couple of modifications to the query, and then execute it against the new virtual cube.