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

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

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 17, 2003

MDX in Analysis Services: Intermediate Concepts - Part 1 - Page 3

By William Pearson

Returning Values within Analysis Manager

The focus of our hands-on examples in this lesson will be upon the use of MDX to access values inside our multidimensional data source. We will explore a couple of approaches to the retrieval of values within Analysis Manager in this section. One of our primary objectives will be to leverage the use of the current member concept.

To prepare for the lesson, let's shift from the Warehouse cube we used in Lesson One to the Budget cube that, like the Warehouse cube, is supplied as a sample with the Typical installation of Analysis Services. We will create a calculated member within the Budgets cube by following the steps below:

From the Analysis Manager console, and at the Cubes folder within the FoodMart 2000 database sample:

1.      Expand the Cubes folder (seen in the illustration below), by clicking the "+" sign to its left.

Illustration 1: Sample Cubes provided with the Analysis Services Installation

2.      Right click the Budget cube.

3.      Click Edit from the context menu that appears.

4.      When the Cube Editor screen appears, click the Data tab at its lower left (the Data Viewing pane).

The Data Viewing pane is activated, and appears as shown below in Illustration 2.

Illustration 2: The Cube Editor Data Viewing Pane, Budget Cube (Compressed View)

5.      Drag the Store dimension from the top pane down, and drop it on the existing top row axis label (Level 02 in the illustration, but this may differ depending upon previous actions performed in our individual sample databases, etc.), to replace the existing dimension (Account, in the case of the illustration) in the rows axis.

Dropping the icon that appears over the heading currently in place (a small, double-headed arrow appears at the "drop" point) "swaps" the existing dimension to the top and Store below, in the original dimension's old place.

The Data Viewing pane now appears as shown below:

Illustration 3: The Data Viewing Pane after our Dimension "Swap"

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