- 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
Next in Our Series
In this article, we explored performing drillthrough with multidimensional cubes. First, we discussed scenarios in which drillthrough from summary cube data to the underlying details can be valuable to information consumers. Next, we examined some of the strengths and weaknesses of the capability in MSSQL 2000 Analysis Services.
We examined the steps that need to be taken to implement drillthrough as a part of setting up a sample drillthrough in the Cube Editor, in order to focus on concepts in an introductory fashion. We then practiced the creation and use of an example MDX query that used the DRILLTHROUGH statement to retrieve rowsets from the source data underneath cube cells. We explored the syntax for the DRILLTHROUGH statement, and discussed options that surrounded this functionality, as a part of our hands-on exercises.
In our next article, "Improving Performance within MDX," we will explore methods for optimizing performance from our MDX queries, including the use of caching to load a commonly used slice of a cube into memory, making for faster retrieval in prospective operations. We will discuss the creation scope for caches, where they are similar to named sets, in the two scope options available. We will explore creating caches, both through the use of the CREATE CACHE statement and through the WITH statement that we have discussed in earlier articles.