Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

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.

  • + Share This
  • 🔖 Save To Your Account