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

date criteria in MDX member formula

February 2 2013 at 10:58 PM
No score for this post
Kiran 
from IP address 69.246.214.43

Hi
I am trying to write a MDX member formula which has to be date dependent.
So for all 2010 and 2011 dates = formula1,
rest of the dates = formula2.
I am trying to use case statement
case
while ([date].CurrentMember > [2011-12-31])
then
formula2
else
formula1
end

this does not work since the search_condition is not valid.

I can use UDAs to tag 2010 and 2011 dates with UDA1 and other dates with UDA2 and use isUda in case statement. But I would like to know if I can avoid using UDAs and achieve this with MDX formula.

Please advise

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

  1. urgent.. please help - mdx: case statement with dates as search_condition - Anonymous on Feb 11, 2013, 9:03 AM
  2.  
  3. Re: date criteria in MDX member formula - GlennS on Feb 11, 2013, 11:36 AM
    1. Re: date criteria in MDX member formula - Kiran on Feb 12, 2013, 12:57 AM
     
  4. Re: date criteria in MDX member formula - Jennifer H on Feb 11, 2013, 12:07 PM
    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.