Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

@CURRMBRRANGE to MDX query Expand / Collapse
Author
Message
Posted Tuesday, June 12, 2012 12:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 6:50 AM
Points: 1, Visits: 52
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

Post #1314223
Posted Monday, March 18, 2013 6:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 22, 2013 12:06 PM
Points: 2, Visits: 5
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
Post #1432426
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse