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:49 AM
No score for this post
 
from IP address 69.246.214.43


Response to Re: date criteria in MDX member formula

Hi Jennifer

Thanks for the quick response.
I tried to use DatePart in the member formula.
It didnt throw me any syntax error but during retrieval I got error "invalid date specification in function [DatePart]"

My date members are in format 2011-01-31, 2011-02-28 so on..

Shud the date members be in any specific format? Also shud the dimension be tagged as any specific dimension type?


thanks,

Kiran M

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

  1. Substring - PD on Feb 12, 8:21 AM
    1. Re: Substring - GlennS on Feb 12, 9:38 AM
      1. Re: Substring - Kiran on Feb 20, 9:35 AM
    2. Re: Substring - Kiran on Feb 20, 9:40 AM
      1. Re: Substring - Gary Crisci on Feb 20, 11:24 AM
        1. Re: Substring - kiran on Feb 26, 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.