Re: About Calculated Members

#1

Hi Ricardo,
have you tried something like this and it didn't work?

Iif([MyDimension].CurrentMember.Level is [MyDimension].[MyLevel], 0, 1)

"Ricardo Antunez" <Ricardo Antunez (AT) discussions (DOT) microsoft.com> wrote in m
essage news:3AB956E1-DD7B-4277-9038-D76839891856 (AT) microsoft (DOT) com...

Quote:

Hi

I need to create a calculated member in which I need to have a value if a
level of one of the cube dimensions has a certain value, or zero otherwise

it may be like this

Iif( xxxxxxx = "CD", <<measure>>, 0 )

where xxxxxxx is the reference to the dimension level

I have tried some options, but didn't work

My question is if it is posible to do this and how

Thanks

#2

Hi Ricardo,
if I understand, you want to test if the actual member is the member you
want??
You can't reference to the CurrentMember of a level, but you can reference
to the CurrentMember of the dimension, so, you can use:

IIF( [Products].CurrentMember is [Products].[Type].&[Fruits], 1, 0)

#3

Hi Francesco, thank you for your time

I tried what you said, but it works only when I filter in that specific dimension or when I show that specific dimension, but the "All Products" returns zero

Thank you again
Ricardo

"Francesco De Chirico" wrote:

Quote:

Hi Ricardo,
if I understand, you want to test if the actual member is the member you
want??
You can't reference to the CurrentMember of a level, but you can reference
to the CurrentMember of the dimension, so, you can use:

IIF( [Products].CurrentMember is [Products].[Type].&[Fruits], 1, 0)

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

Re: About Calculated Members

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

Re: About Calculated Members - 06-15-2004 , 05:22 PM

Re: About Calculated Members - 06-16-2004 , 11:33 AM

Re: About Calculated Members - 06-16-2004 , 03:15 PM