MS SQL Server OLAP - newbie question on calculated members

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

newbie question on calculated members

blom0344

2005-08-26, 3:23 am

In a Sales Cube I need to pre-calculate margin figures for this year
and previous year sales.
My time table stores dimensions that indicate - for each sales date -
whether it is a Year-To-Date date.

In my case for year-to-date dates in year 2005, the value from the time
table is: 'JTDCY'

To calculate the margin within the Cube I came up with:

(Sum(& #123;JTDCY},(Measure
s.Amount -
Measures.Cost))/Sum(& #123;JTDCY},(Measure
s.Amount)))

This seems to work, but I am at a loss why!

1. Is this the correct way to define a calculated member?
2. Are there alternative expressions?
3. How does analysis server know which dimension/table to evaluate for
the member 'JTDCY'? To me, it seems like some magical trick!

(We only work with offline cubes , btw)

Sponsored Links