@CURRMBRRANGE to MDX query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » @CURRMBRRANGE to MDX query

@CURRMBRRANGE to MDX query

Rate Topic

Display Mode

Topic Options

Author

Message

gurusankar.g

Posted Tuesday, June 12, 2012 12:50 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 13, 2012 11:46 PM
Points: 1, Visits: 51

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

santade

Posted Monday, March 18, 2013 6:26 PM

Forum 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 »

Permissions