Converting Calc Script to ASO MDX
Summary
Converting Calc Script to ASO MDXContent
All,
We have a member formula in one of my planning application as shown below. I got a requirement to implement this member formula in our ASO reporting application using MDX. As I am not that familiar with MDX and this is kind of an immediate requirement, Could you anyone help me to convert this into MDX, if possible?
IF ( @ISIDESC ( "AB" ) ) | ||
IF ( @ISIDESC ( "129" ) ) | ||
"90007" * 1.6 ; | ||
ELSEIF ( @ISDESC ( "AB" ) ) | ||
"90007" ; | ||
ELSE | ||
@SUMRANGE ( "90008" , @CHILDREN ( "AB" ) ) ; |
ENDIF ;
ELSE |
#MISSING ;
ENDIF ;
'AB' is the parent of '129' and both are Product dimension members. '90007' and '90008' are members of account dimension.
0