Hi All,

Have a look at the following link :
http://msdn.microsoft.com/library/de...ons_rowset.asp


which field can i use to diffrentiate between Measures and Calculated
Measures when retriving Cube information from MDX ?

This thread discussed how to determine the difference:

http://groups-beta.google.com/group/...rver.olap/msg/
deb60eb02d960eae
From: "Jéjé"
Date: Mon, 7 Feb 2005 09:26:51 -0500
Subject: Re: how to verify if the current measure is a calculated one?

thanks.
I'm just surprise that, there is no simple function to test this.

I also found this method:
Intersect({Measures.currentmem*ber}, Measures.members).count

the count = 1 if the measure is a standard measure or 0 if its a
calculated
one.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Another alternative is Measures.CurrentMember.Properties("MEMBER_TYPE")

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote