Forum Discussion

jvonallmen's avatar
jvonallmen
New Contributor III
4 years ago

How can I use a Business Rule to sort a Member List in alphabetical order?

    Namespace OneStream.BusinessRule.Finance.XFR_MemberListAlphabetical Public Class MainClass '-----------------------------------------------------------------------------------------------...
Finance
amvillaruel's avatar
amvillaruel
New Contributor II
3 years ago

Hello, do we have an example where this is used in account dimension? I tried it but it would only show the parent account. For example, I use A#ParentAccount.Base as the Memberliststart, the cube view will only show the ParentAccount and not the base members.

I then tried to switch the dimension to Entity in the cube view and also the Memberliststart to E#TopEntity.Base, and it works just fine so I'm wondering if this only works for Entity dimension.

  • amvillaruel's avatar
    amvillaruel
    New Contributor II
    3 years ago

    Hi All,

    I was able to make it work for the Account Dimension by using the Finance Metadata function called GetMembersUsingFilter with this syntax:
    BRApi.Finance.Metadata.GetMembersUsingFilter(si, dimensionName, memberFilter, removeDuplicates, dimDisplayOptions, memberDisplayOptions)

    The above worked better than the Members function with syntax:

    api.Members.GetMembersUsingFilter(args.MemberListArgs.DimPk, MemberListstart, Nothing).

    Hope this helps!