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 11, 2005

Introduction to MSSQL Server Analysis Services: Presentation Nuances: CrossTab View - Same Dimension - Page 9

By William Pearson

Verify Results - from the Cube Browser

We will conclude our practice session by examining the results of our handiwork from two perspectives: from the Analysis Manager, via the Cube Browser, and from a "reporting perspective," using the MDX Sample Application.

1.  From our present position within the Cube Editor, click the Data tab to open the browser and see cube data.

2.  Drag the Store Location dimension down, and drop it atop the MeasuresLevel heading (column axis), as depicted in Illustration 31.

Click for larger image

Illustration 31: Swapping the Store Location and Measures on the Data Tab "X" Axis

3.  Drag the Store dimension down, and drop it atop the Product Family heading (row axis), as shown in Illustration 32.

Click for larger image

Illustration 32: Swapping the Store and Product Dimensions on the Data Tab "Y" Axis

We can see the Store dimension in both the "X-" and "Y-" axes on the Data Tab.

4.  Select % Profit Contribution in the Measures dimension filter, atop the Cube Browser, as depicted in Illustration 33.

Illustration 33: Filtering for the New Calculated Member % Profit Contribution

5.  Expand the USA Store Country in the row axis by clicking the "+" sign to the left of USA.

6.  Expand the Store State level for Washington (WA).

7.  Scroll over to the right in the Cube Browser, until Seattle, WA appears under the Store City heading (and thus Seattle, WA is the left-most column in the data area), as shown in Illustration 34.

Illustration 34: Examining % Profit Contribution (Compressed, Partial View)

We can see that the components appear to be in place and working from the Cube Browser. We will next look at the data from a "reporting perspective," and ascertain that our structural enhancements to the cube allow us to precisely meet the presentation requirements of the information consumers.

8.  Select File -> Exit (main menu) to leave the Cube Editor.

9.  From the Analysis Manager main menu, select File -> Exit.

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