This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

MDX Formula Using Variables

February 28 2012 at 8:02 PM
No score for this post
from IP address

Hi all,

I need some help.

I have a ASO cube and I need use variable but I did not get good result.

I used this calc:
In my dimension Scenario I have a member with this formula

Sum(CrossJoin({MemberScenario}, {[&FirtsMonth]:[&FinalMonth]}))

I want sum values between a first month to final month.

This calculation is not working in the error message appears that the variable does not exist.

FirtsMonth was created in the EAS and I am using the native user admin.

Best regards,

Anderson Pereira

Scoring disabled. You must be logged in to score posts.Respond to this message   

  1. Re: MDX Formula Using Variables - Javier on Feb 29, 2012, 8:04 AM
    1. Re: MDX Formula Using Variables - Leonardo on Feb 29, 2012, 9:46 AM
  2. For what it is worth -- - angie on Mar 5, 2012, 11:16 AM
    1. Variables - Sreenivas on Apr 4, 2012, 4:51 PM
      1. Re: Variables - Anonymous on Apr 4, 2012, 6:06 PM

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.