urgent.. please help - mdx: case statement with dates as search_conditionFebruary 11 2013 at 9:03 AM
No score for this post
from IP address 126.96.36.199
Response to date criteria in MDX member formula
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