Forum Discussion

jvonallmen's avatar
jvonallmen
Icon for OneStream Employee rankOneStream Employee
4 years ago
Solved

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
  • NaeemPathan's avatar
    NaeemPathan
    4 years ago

    Hi Jerry,

    Not sure if you had a response on this, but what you could do is by creating the parameter as a 'Member list' and in your Member filter reference a business rule which sorts your entities. I have attached a screenshot of an example which you could use, you can change the entity filter variable to suit your requirements. 

     

     

     

    Regards,

    Naeem

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!