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

 Return to Index  

urgent.. please help - mdx: case statement with dates as search_condition

February 11 2013 at 9:03 AM
No score for this post
Anonymous 
from IP address 69.246.214.43


Response to date criteria in MDX member formula

 

Hi guys

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.

is there any approach to achieve the above mdx formula.

thanks in advance


Kiran M

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
 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.