« AS2000 Cube Documentation Tool | Main
Thursday
Nov072002

Creating Calculation Dimensions

This is an example of a calculation dimension built in Analysis Services 2000. A calculation dimension is a special dimension for the sole purpose of containing MDX calculations.

The download is a 22k zip file containing:

  • OLAP cab
  • Access database

Why a Calculation Dimension?

A calculation dimension is potentially applicable when a cube contains multiple measures. By building calculations in a separate dimension, there is an intersection point with all measures, reducing the number of calculations that must be built.

If your cube contains only one measure there is no benefit to a calculation dimension.

Installation

You need to know your way around Analysis Manager. If these terse instructions are confusing then this download is not intended for you.

  1. unzip anywhere
  2. restore the OLAP cab
  3. edit the data source to point to the .mdb file

Key Points

  • a foreign key for the calculation dimension is added to the fact table courtesy of a view (Access query)
  • member 1 of the calculation dimension represent the "just the cube", no calculation; it is the only physical member
  • the example year-to-date calculation operates against all measures

This is a trivial example. You can do interesting things with a calculation dimension. For instance, it can be a parent/child dimension, allowing organization and navigation of calculations.

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments (5)

This sound sinterestign and I see a use for it. Could you please convert the example to SSAS 2008?
Thank you.
Ar

April 23, 2010 | Unregistered CommenterArt

Your essay was very good, in your articles I learned a lot, as someone who just learn English beginners. I'm honored to see such worthy of study of articles. This is the sea of knowledge.
I like it very much. I am coming back tomorrow to continue reading.
Welcome to my shop , come to me for communication. I learn got more. What you need. Come to my store, I will give you a better discountreplica chloe handbags

November 22, 2010 | Unregistered CommenterDelores R. Garcia

I really enjoyed the blog. I have just bookmarked. I am reguler visitor of your website i will share it with my friends,Thanks UGG Boots

September 26, 2011 | Unregistered Commenterugg boots

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>