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
from IP address

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
while ([date].CurrentMember > [2011-12-31])

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   

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.