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

Re: date criteria in MDX member formula

February 11 2013 at 12:07 PM
No score for this post
Jennifer H 
from IP address 66.77.129.3


Response to date criteria in MDX member formula

Try this:

Case
When DatePart ([Date].CurrentMember, DP_YEAR) > 2011
Then formula2
Else formula1
End

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

  1. Re: date criteria in MDX member formula - Kiran on Feb 12, 2013, 12:49 AM
    1. Substring - PD on Feb 12, 2013, 8:21 AM
      1. Re: Substring - GlennS on Feb 12, 2013, 9:38 AM
        1. Re: Substring - Kiran on Feb 20, 2013, 9:35 AM
      2. Re: Substring - Kiran on Feb 20, 2013, 9:40 AM
        1. Re: Substring - Gary Crisci on Feb 20, 2013, 11:24 AM
          1. Re: Substring - kiran on Feb 26, 2013, 9:14 AM
     

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.