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 4

By William Pearson

6.       Select Calculated Member under Insert (top menu).

(NOTE: For more on creating calculated members, see Lesson One).

The Calculated Member Builder appears.

7.      Type MyCalcMem2 into the Member Name box.

8.      In the Value Expression box, input the following:


The Value Expression box appears as shown below.

Illustration 4: The Value Expression Box with Inserted Calculation

9.      Click OK.

MyCalcMem2's values equal one-twelfth of the respective Amount of each row (the "current" row). The calculation is performed for every cell in the MyCalcMem2 column, basing its value, in each case, upon the Store dimension's current member.

10.  Review the newly created MyCalcMem2 column, comparing it to the illustration below.

Illustration 5: The MyCalcMem2 Value is Based upon the Store Dimension's Current Member

11.  In the Cube tree, select MyCalcMem2 in the Calculated Members folder for the Budget cube.

The Basic tab of the Properties pane appears underneath MyCalcMem2.

12.  Select the Parent Dimension property of MyCalcMem2, on the Basic tab.

Because MyCalcMem2 has Measures as its Parent Dimension, we see that MyCalcMem2 is technically a Calculated Measure.

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