Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Optimizing the CROSSJOIN() Function
Process the Clone Cube
1. Right-click the new SSP014_OPT_CROSSJOIN cube.
2. Select Process… from the context menu that appears, as depicted in Figure 4.
Figure 4: Select Process… from the Context Menu
The Process a Cube dialog appears, as depicted in Figure 5, with the processing method defaulted to Full Process (as this is the first time the cube has been processed
Figure 5: Full Process Selected in the Process a Cube Dialog
3. Click OK to begin processing.
Processing begins. The Process viewer displays various logged events, then presents a green Processing completed successfully message, as shown in Figure 6.
Figure 6: Indication of Successful Processing Appears (Compact View)
4. Click Close to dismiss the viewer.
We will are now ready to work with the SSP014_OPT_CROSSJOIN cube in the MDX Sample Application.
5. Exit Analysis Manager when ready.
We now have a clone cube with which we can pursue our examination of CROSSJOIN() optimization. Let’s initialize the MDX Sample Application, as a platform from which to perform our practice exercises, taking the following steps:
1. Start the MDX Sample Application.
We are initially greeted by the Connect dialog, depicted in Figure 7.
Figure 7: The Connect Dialog for the MDX Sample Application
The figure above depicts the name of my server, MOTHER1, and properly indicates that we will be connecting via the MSOLAP provider (the default).
2. Click OK.
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 new SSP014_OPT_CROSSJOIN cube in the Cube drop-down list box.
5. Click File —> New to open a blank Query pane.
The MDX Sample Application window should resemble that shown in Figure 8, complete with the information from the SSP014_OPT_CROSSJOIN cube displaying in the Metadata tree (left section of the Metadata pane).
Figure 8: The MDX Sample Application Window (Compressed View)