MDX Function Iif

[Belka]

Here is the scenario: I need to build a calculated member based on specific member (value) of the dimension. Let's say dimension product has members A,B and C. The calculated member should be:
If (Product = 'A', (measures.qty * measures.price),null)
Thanks

 

[AjitG]

Please refer to the link from MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agmdxadvanced_82lh.asp

Ajit

 

[Welshbird]

IIf(Product = A, (Measures.[qty]* Measures.[price]),''))

I think this is right - but I'm on the wrong computer to check it out. Let me know if not and I'll try again!


Fi.

 

[Guest_imported]

Did the reponse from Willif work? I tried the same on a custom rollup function and got an error. I don't think it liked the empty ELSE part but I'm not sure.

Thanks