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 12 2013 at 9:38 AM
No score for this post
GlennS 
from IP address 63.127.232.196


Response to Substring

Since these are member names and I assume you have parents that denote the years, you could use the ISancestor function for the currentmember. Note ISAncestor does both ancestors and descendants dependent on the order of members so something like
Case When ISANCESTOR(time.currentmember,time.[FY10]) Then
....
When...
End

Note you might need to switch the two paramaters, I never remember which goes first

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

  1. Re: Substring - Kiran on Feb 20, 2013, 9:35 AM
  2.  

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.