MDX Newbie question 1

[SQLBI]

Hi,

I'm totally new to MDX and need to add a Calculated Member to my SQL 2k Analysis Services Cube.

I've gotten as far as adding the member, but at present it is calculating for all members in a particular dimension.

[Measures].[Revenue Inc Tax]/[Measures].[Visits In Period]

What i want to do is ONLY have this calculation performed on 1 specific member of my dimension, by doing something like

 IF [Indicator].[Indicator Id] = 3 THEN [Measures].[Revenue Inc Tax]/[Measures].[Visits In Period] ELSE IS NULL

Is this possible and if so, how should i go about it?

Thanks in advance.

Leigh Moore
Business Systems Manager
Vets4Pets Veterinary Group

http://www.vets4pets.eu.com

 

[justins57]

Leigh,

I assume you are using the cube editor to add your calculated member. You can add this logic to the mdx builder for the calculated member.

IIF([Indicator].CurrentMember IS [Indicator].[Indicator Id].[3],[Measures].[Revenue Inc Tax]/[Measures].[Visits in Period],null)

hth,

Justin

 

[SQLBI]

Justin,

Thanks for that, just had to make .[3] .&[3] and it worked perfectly.

Cheers, have a star!

Leigh Moore
Business Systems Manager
Vets4Pets Veterinary Group

http://www.vets4pets.eu.com