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 186.205.1.153

 

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   
Responses

  1. Re: MDX Formula Using Variables - Javier on Feb 29, 8:04 AM
    1. Re: MDX Formula Using Variables - Leonardo on Feb 29, 9:46 AM
     
  2. For what it is worth -- - angie on Mar 5, 11:16 AM
    1. Variables - Sreenivas on Apr 4, 4:51 PM
      1. Re: Variables - Anonymous on Apr 4, 6:06 PM
     
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.