Get Started with Redwood: Oracle Cloud SCM and Purchasing
MDX script for member formula in ASO Cube
Summary
Hi, I am trying to write an if/then statement for a member formula using MDX in ASO cubeContent
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!!
0