@CURRMBRRANGE to MDX query

  • 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

  • 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