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

Forum|Forum|2 years ago
September 27, 2023
2 replies
0 views

N

NicolasArgente

You could use an XFBR

C

Catherine_TeeAuthor

Can I know how to use XFBR?

J

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.

C

Catherine_TeeAuthor

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