Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 7, 2003

Reporting Options for Analysis Services Cubes: MS Excel 2002 - Page 8

By William Pearson

"Going Multidimensional" in Cube Reporting

We will take the a few steps to demonstrate how we can unleash the multidimensional power of our cubes, by making multiple dimensions share the same axis in our PivotTable report. The PivotTable report provides a full realization of the information presentation potential of the multidimensional cube by intersecting dimensions on a single axis, and therefore delivers the full impact of multidimensional data in the "two-dimensional world" of the typical reporting environment.

We will begin by making the Store Type a part of the row axis to make analysis of Store members more powerful, yet more compact.

1.      Drag the Store Type item from the page axis (upper left hand corner of the PivotTable report) to the left of the Store State column, dropping it to the left of Store State. The result set should resemble that shown in Illustration 27.

Illustration 27: Combining the Store Type and Store Dimensions in the Row Axis

We can easily tell that only the Store Type label represents the top level of a dimension, as a drop-down arrow only appears at top levels. We can see in this simple scenario that multiple dimensions (in our case the Store Type and Store dimensions), as well as multiple levels of a given dimension (here, the Store State and Store City levels of the Store dimension), can co-exist on a single axis. The possibilities that emerge are far reaching, indeed.

Now let's add another measure to the report - Unit Sales - to give us more information about store performance.

2.      Drag the Unit Sales item from the PivotTable Field List to the Data section of the PivotTable report (the column under the Year heading in our present report). Once we drop the measure, the PivotTable report should resemble the illustration below.

Illustration 28: Dual Measures now appear in the PivotTable Report (Partial Illustration)

A new Data column appears, and in accordance with its default behavior, represents what appears to be a fourth row dimension.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM