Essbase to MDX

[Database Administrator]

Does anyone have a clue on what the equivelant statements would be in
MDX? This is a calculated measure from db2olap.

IF(@ISMBR("ZONE"))
((VOL->Z002*2)+(VOL->Z003*3))/((VOL->Z002)+(VOL->Z003));
ENDIF

Thanks for any help.
Borf

[Database Administrator]

IIF(ZoneDim.CurrentMember IS [Zone], ((Vol, Z002) * 2 + (Vol, Z003) * 3)) /
((Vol, Z002) + (Vol, Z003)), NULL)

Ohjoo


"Borf" wrote in message
news:1186681572.719279.255900@w3g2000hsg.googlegro ups.com...
> Does anyone have a clue on what the equivelant statements would be in
> MDX? This is a calculated measure from db2olap.
>
> IF(@ISMBR("ZONE"))
> ((VOL->Z002*2)+(VOL->Z003*3))/((VOL->Z002)+(VOL->Z003));
> ENDIF
>
> Thanks for any help.
> Borf
>

[HypExpert]

How would I replicate the following Essbase calc function:

IF(@ISIDESC(330790))
QtrVar=1Q-2Q;
ENDIF