You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MDX script for member formula in ASO Cube

edited Jul 20, 2020 8:23PM in Planning 5 comments

Summary

Hi, I am trying to write an if/then statement for a member formula using MDX in ASO cube

Content

Below is my attempt:


CASE WHEN IS ([EMEA].currentmember,[G305])

THEN
     (([Total Revenue],[Reported],[TOTREV],[Product],[EMEA])  *
([43910],[Statistical Account],[0000],[No_Entity],[Begbalance],[Active],[GAAP Load])) * -1


ELSE ([Total Revenue],[Reported],[TOTREV],[Product]) *
([43910],[Statistical Account],[0000],[No_Entity],[Begbalance],[Active],[GAAP Load])

END

The credit out of G305 is working as expected but the ELSE part is not working.  Any suggestions?

Thanks!!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!