Forum Discussion
5 Replies
You could use an XFBR
Can I know how to use XFBR?
You might want to learn how to write XFBR, because they're a lifesaver in a lot of circumstances.
This said, depending on what you're trying to do, you could be ok with filters, just "the other way around" - instead of filtering on IC members, filter on Entity and then include only IC ones, e.g. E#Group.Base.Where(Text5 StartsWith Equity).Where(IsIC = True). If you're just after a list of names, that will work.
Thanks. However E#Group.Base.Where(Text5 StartsWith Equity).Where(IsIC = True) only can get the Entity (Text5 StartsWith Equity).
If I want to get which Entities have IC transaction with the Entity (Text5 StartsWith Equity). then how?
I had tried use BR below and in cube view put this is not work.
I#ICEntities.CustomMemberList(BRName=CT_ConsolHelper, MemberListName=ICList, Dim=|WFEntityDim|, Query=[E#Segment_Group.base(Text5 <> Equity)]):Name(|MFICDesc|)
For the record, here's a working Member List for a similar case: https://community.onestreamsoftware.com/t5/Application-Build/Define-and-Edit-Text-for-IC-members/m-p/28373/highlight/true#M2933
