Helllo all,

I use an account-dimension in my model. Now I want to create a
calculated member, which only is true when a specific member in the
account-dimension is selected.

For example, my account-dimension has the following members:

- Sales Outside
-- sales North outside
-- sales West inside
- Sales Inside

Only when I select the member 'Sales Inside' the calculation must be
made, else, just de default values.

Anyone an idea how to do this?

Thanks in advance.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Below is the MDX you can use. Change calculation and no
calculation as per your requirement.

iif(accountdimension.currentmember is 'Sales Inside',
calculation, no calculation)

Abhinav Kumar
akumar (AT) itmag (DOT) com.au

I also thought it was simple, but not...

The message I get is: Syntax error, Token not valid:
iff(Account.CurrentMember is ^'Sales Insid^e',

Can I only check on specific name or is it also possible to check, for
example on member value or something?
Or any other solutions?

Thanks in advance.

"Abhinav Kumar" <akumar (AT) itmag (DOT) com.au> wrote

You schould use

iif(accountdimension.currentmember.uniquename = "[Account].[Sales Inside]",
calculation, no calculation)

Vladimir Chtepa


"Marco" <m.linders (AT) pforb (DOT) com> schrieb im Newsbeitrag
news:cb8s83$sjc$1 (AT) news3 (DOT) tilbu1.nb.home.nl...