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

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

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   

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

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