How do I filter I#ICEntities exclude E#Group(Text 5 = Equity) in Cube View and Excel Add In?

[NicolasArgente]

You could use an XFBR

[Catherine_Tee]

Can I know how to use XFBR?

[JackLacava]

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.

[Catherine_Tee]

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|)

[JackLacava]

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...