How do I filter I#IC Entities in CV?

Hi Aurora

I use a custom list to filter the ic members (by entity hierarchies, attributes and more). It looks like this in a cubeview:

I#Root.CustomMemberList(BRName=ConsolHelper, MemberListName=ICList, Dim=|WFEntityDim|, Query=[E#Group.base]):Name(|MFICDesc|)

And here is the custom list section of the related business rule (here: ConsolHelper):

Case Is = FinanceFunctionType.MemberList
	If args.MemberListArgs.MemberListName.XFEqualsIgnoreCase("ICList") Then
		Dim oMemberListHeader As New MemberListHeader(args.MemberListArgs.MemberListName)
		Dim sQuery As String = args.MemberListArgs.NameValuePairs("Query")
		Dim sDim As String = args.MemberListArgs.NameValuePairs("Dim")
		Dim oEntDimPK As DimPk = api.Dimensions.GetDim(sDim).DimPk
		Dim oEntMemberInfos As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(oEntDimPK, sQuery, Nothing)
		Dim oICMemberInfos As New List(Of MemberInfo)
		
		Dim test2 As MemberInfo
		For Each test As MemberInfo In oEntMemberInfos
		
			test2 = New MemberInfo(api.Members.GetMember(dimtype.IC.Id, test.Member.MemberId))
			oICMemberInfos.Add(test2)
			
		Next
		
		Dim oMemberList As New MemberList(oMemberListHeader, oICMemberInfos)
		Return oMemberList
	End If

You can use all member filter as query, the api.Members.GetMembersUsingFilter(oEntDimPK, sQuery, Nothing) function will give you back the correct list.

In your case:

I#Root.CustomMemberList(BRName=<A Business Rule>, MemberListName=ICList, Dim=|WFEntityDim|, Query=[E#<An Entity Node>.base.Where((InUse = True) and (Text1 = SalesEntity))]):Name(|MFICDesc|)

should work.

how would you amend this to work in Cubes>Data Access as a way to limit the IC partners you can post entries too?

How do I filter I#IC Entities exclude Entities Text 5 = Equity in CV?