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

Re: BSO TO ASO IF @ISMBR(@IRSIBLINGS

June 16 2017 at 4:35 PM
No score for this post
Amarnath 
from IP address 165.156.39.29


Response to BSO TO ASO IF @ISMBR(@IRSIBLINGS

you have siblings function in ASO and combining that with CONTAINS function you get something like below

CASE WHEN (Contains([Years].CurrentMember,Siblings(&CurYr, RIGHT)) AND IsLeaf([OEP_Planned Scenarios].CurrentMember)) THEN


I believe this should work

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

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.