Forum Discussion

CarlosAlvear's avatar
CarlosAlvear
Contributor
4 months ago

Call a dynamic member list from a member formula

Hi all,

 

Does anyone know how to call a dynamic member list inside a member formula (well, I need it for a dynamicCalc but it can be generalized). I can call the member list in a CV with the call: 

I#ICEntities.CustomMemberList(BRName= BRName, MemberListName= MemberListName, Param1 = Param1, Param2 = Param2, Param3 = Param3)

 

In the Design and Reference (Examples of Key Functions in Use (onestream.com)), we find an example of a static member list. 

Thank you for the help.

Regards

  • TheJonG's avatar
    TheJonG
    Contributor III
    4 months ago

    You can reference a dynamic member list inside of the api.Members.GetMembersUsingFilter. See the example below using the member filter you referenced. You can put any member filter that works in a Cube View in the memberFilter argument of that function.

     

    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, I#ICEntities.CustomMemberList(BRName= BRName, MemberListName= MemberListName, Param1 = Param1, Param2 = Param2, Param3 = Param3), Nothing)