Reading Sum of measure

#1

Hi there,
How Can I read the sum of Measure in calculated members ? Here is my case..
Is there any way to read the total ( in this case 200 ) in Calculated
members ?
Dim ZipCode Population Calculated members result
12345 100 200
23456 50 200
54678 20 200
09990 10 200
10000 20 200
--------------------- --------
200 200

Thanks
-Kris

#2

You can use tuple. For example

([Population], [ZipCode].[All ZipCodes])

Ohjoo Kwon

"Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi there,
How Can I read the sum of Measure in calculated members ? Here is my
case..
Is there any way to read the total ( in this case 200 ) in Calculated
members ?
Dim ZipCode Population Calculated members result
12345 100 200
23456 50 200
54678 20 200
09990 10 200
10000 20 200
--------------------- --------
200 200

Thanks
-Kris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Reading Sum of measure

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Reading Sum of measure - 03-10-2005 , 12:41 PM

Re: Reading Sum of measure - 03-10-2005 , 08:00 PM