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
Kiran 
from IP address 69.246.214.43


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.

Date_dimension
|-> 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.

Thanks

Kiran M

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

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.