MDX script for member formula in ASO Cube — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

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!