This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Re: Substring

February 20 2013 at 9:35 AM
No score for this post
from IP address

Response to Re: Substring

Thanks Glenn

My date dimension is in the format below with ~ operator. Its a flat dimension with month ends. So all members are level 0 members.

|-> 2011-01-31
|-> 2011-02-28
|-> 2011-03-31
and so on.

I have used Substring as well as DatePart functions in mdx member formulae.
- Substring([Date].CurrentMember,1,4) - failed during formulae verification
- DatePart([Date].CurrentMember,DP_YEAR) - verified successfully but during retrieval threw error "Invalid date spedified in function [DatePart]"

Please help.


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.