This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
  << Previous Topic | Next Topic >>Return to Index  

BSO TO ASO IF @ISMBR(@IRSIBLINGS

June 14 2017 at 8:35 PM
No score for this post
Vic 
from IP address 189.216.114.32

Hello, I need to convert this BSO member formula to an ASO member formula, I have read the

If(@ismbr(@iRSIBLINGS (&CurYr)))
if(@ismbr(@relative("Planned Scenarios",0)))

calculation
endif
endif

I have tried the following but is not working:

CASE
WHEN IS(MemberRange([Years].Lead(1),[&OEP_CurYr].LastSibling) AND
IsLevel([OEP_Planned Scenarios].CurrentMember, 0) THEN
calculation
END

I really apreciate any help you can provide.

regards

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

Gary Crisci

216.66.5.46

Re: BSO TO ASO IF @ISMBR(@IRSIBLINGS

No score for this post
June 15 2017, 12:44 PM 

Can you be more specific about what is not working? Is it syntax, not giving correct results, or not giving any results?

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

165.156.39.29

Re: BSO TO ASO IF @ISMBR(@IRSIBLINGS

No score for this post
June 16 2017, 4:35 PM 

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   
 
  << Previous Topic | Next Topic >>Return to Index  

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.