June 12, 2012 at 12:50 am
Hi ,
Please help me out to get the Proper MDX query ..
Below is my Essbase formula need to be converted to MDX query ..
IF(@ISMBR(Actual,Budget,Forecast))
(@SUMRANGE (A02, @CURRMBRRANGE(Period,LEV,0,-12,0)) /
(@SUMRANGE (BusPool, @CURRMBRRANGE(Period,LEV,0,-12,0))/13))*100;
ENDIF;
I have tried the below but it is showing syntax error near the LEVEL ,
(SUM(Crossjoin({[Dim Variable].[Parent Variable Id].&[69]},{
RelMemberRange(
[Dim Period].[Period ID].CurrentMember, 12,0,LEVEL)}))/
SUM(Crossjoin({[Dim Variable].[Parent Variable Id].&[363]},{
RelMemberRange(
[Dim Period].[Period ID].CurrentMember, 12, 0,LEVEL)})/13))*100
Please correct me,,
Thanks in Advance
March 18, 2013 at 6:26 pm
Hi buddy!!!
I have a lot of issues converting Essbase formulas to Analysis Services - could you help me about convert ISLEV to MDX? I am experiencing tag #VALUE on the field. Do you have any document that explain some conversions formulas?
Thanks a lot!
Gustavo
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply