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

For what it is worth --

March 5 2012 at 11:16 AM
No score for this post
angie 
from IP address 146.235.0.124


Response to MDX Formula Using Variables

We use them all the time - but we found we had the least issues if we defined the variable value with the bracket -- so we have a LastWk variable and the value is [2012W05]. The the formula looks like this:

OR ( Is(Scenario.CurrentMember, LY) AND Is(Time.CurrentMember, &LastWk) AND

So you might give that variation a try... we have others as well - but this one has least amount of issues.

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

  1. Variables - Sreenivas on Apr 4, 4:51 PM
    1. Re: Variables - Anonymous on Apr 4, 6:06 PM
     

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.