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

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?


Kiran M

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

  1. Substring - PD on Feb 12, 2013, 8:21 AM
    1. Re: Substring - GlennS on Feb 12, 2013, 9:38 AM
      1. Re: Substring - Kiran on Feb 20, 2013, 9:35 AM
    2. Re: Substring - Kiran on Feb 20, 2013, 9:40 AM
      1. Re: Substring - Gary Crisci on Feb 20, 2013, 11:24 AM
        1. Re: Substring - kiran on Feb 26, 2013, 9:14 AM

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