- About the Series
- Introduction to Drillthrough
- Overview of Drillthrough In Analysis Services
- Enabling Drillthrough for an OLAP Cube
- Reprocessing the Cube to Include Drillthrough
- Drilling through from Analysis Services
- Drilling through from an MDX Query
- The Drillthrough-enabled MDX Syntax in Action
- Running the DTS Package and Viewing Query Results
- Next in Our Series
Reprocessing the Cube to Include Drillthrough
We will now reprocess the cube to make our drillthrough enhancements permanent.
Select the Tools top menu item.
Select Process Cube on the cascading menu, as shown in Figure 8.
Figure 8 Select Process Cube (circled in red).
We can also click the Process Cube button (shown in Figure 9) to accomplish the same thing.
Figure 9 Process Cube button.
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.)
A dialog box 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 box appears in Figure 10.
Figure 10 "Just say no" to Storage Design.
Click No to continue.
The Process a Cube dialog box appears. Here we can select from three processing options:
- Incremental update
- Refresh data
- Full Process
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 Process and leave all else as-is, as shown in Figure 11.
Figure 11 Select Full Process.
Select the Full Process radio button.
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 shown in Figure 12.
Figure 12 Processing was completed successfully.
Click Close on the Process log window.