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 Dec 15, 2003

Introduction to MSSQL Server 2000 Analysis Services: Using Calculated Cells in Analysis Services , Part II

By William Pearson

About the Series ...

This is the eighteenth article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, Creating Our First Cube, the primary focus of this series is an introduction to the practical creation and manipulation of multidimensional OLAP cubes. The series is designed to provide hands-on application of the fundamentals of MS SQL Server 2000 Analysis Services ("MSAS"), with each installment progressively adding features and techniques designed to meet specific real - world needs. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial article, Creating Our First Cube.

Note: Service Pack 3 updates are assumed for MSSQL Server 2000, MSSQL Server 2000 Analysis Services, and the related Books Online and Samples.


In this article, we will extend the exploration of calculated cells that we began in our last session, Using Calculated Cells in Analysis Services, Part I. In Part I we learned that calculated cells offer functionality previously reserved for calculated members, custom members, and custom rollup formulas (all of which we have explored in previous articles) to a specific range of cells-or even to a single cell. We will revisit the construction of a calculated cell, touching upon another means of creating one: through an MDX query.

In this lesson, we will do the following:

  • Overview the creation of calculated cells from the perspective of an MDX query
  • Discuss two approaches to the creation of a calculated cell via an MDX query
  • Discuss the ramifications of the two approaches, within the context of scope assigned by each
  • Practice creation of a calculated cell using the WITH clause in an MDX query
  • Parallel the methods within the MDX query to mirror the actions we performed in Using Calculated Cells in Analysis Services, Part I within the Analysis Services Manager and associated subcomponents, including:
    • creation of a calculated cell;
    • formatting of calculated cell contents;
    • manipulation of other cell properties, such as FORE COLOR and BACK COLOR, to enable exception highlighting.

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