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 12 2013 at 12:57 AM
No score for this post
 
from IP address 69.246.214.43


Response to Re: date criteria in MDX member formula

Hi Glenn

The Dates dimensions is tagged as None, and the members are in 2011-01-31, 2011-02-28 format.

I am trying to use this date member as criteria for case statement.
so

case
when ([Date].CurrentMember) >2011
then
formula1
else
formula2
end

I also tried using DatePart function as
when DatePart ([Date].CurrentMember, DP_YEAR)>2011 but I got an error during retrieval as "invalid date specification in function [DatePart]"

Please suggest

Thanks

Kiran M

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

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.