Introduction to MSSQL Server 2000 Analysis Services: Drilling Through to Details: From Two Perspectives - Page 4
March 3, 2003
The Drillthrough Settings dialog, shown in Illustration 7 below, warns us that the cube must be saved for the changes we have just made to take effect, as shown below.
15. Click OK.
We now need to process the cube to implant our drillthrough setup.
16. Select the Tools top menu item.
17. Select Process Cube on the cascading menu, as shown in Illustration 8 below:
Note that we might have clicked the Process Cube button (shown in Illustration 9) to accomplish the same thing.
We receive another warning about saving the cube (unless we made it a special point to save it after our changes and immediately before the last step.)
18. Click OK.
A dialog appears warning us about aggregations and giving us the opportunity to take advantage of the Storage Wizard to help us with the aggregation design process. The dialog appears below.
19. Click No to continue.
The Process a Cube dialog appears. Here we can select from three processing options as follows:
We are also given the option to incrementally update the dimensions of this cube, as well as to specify additional cube processing options. We will select Full Processing, and leave all else as it is, as shown in Illustration 11.
20. Select the Full Process radio button.
21. Click OK.
The cube begins processing, displaying a Process Log window. Once it has finished, a green message across the bottom of the Log window indicates this, as depicted in the next illustration.
22. Click Close on the Process Log window.
Drilling through from Analysis Services
We have now enabled drillthrough from the cube editor, and reprocessed the cube to embed the drillthrough design into its structure. We must do this whether we intend to drill through from Analysis Services, as we will do next, or from an MDX Query. In either case, drillthrough must be enabled within the cube before we can perform a drillthrough.
Performing a Drillthrough to the Details
The data is again retrieved in the data Preview pane. We can test the results of our work by double-clicking on a given cell and observing the drillthrough process. First, let's expand year 1998 by double clicking the 1998 column label.
23. Expand year 1998 by double clicking the 1998 column label.
24. Scroll over so that only 1998 Q1 through Q4 appears, as shown below.