The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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

marisolbritton's avatar
marisolbritton
New Contributor III
4 years ago

Tried this and it works!! Question though, what if I want to be able to sort on different hierarchies within the same dimension.  Does it mean I have to create separate BRs for each of them or can I incorporate them into one BR?  Thanks in advance

Mike_Sabourin's avatar
Mike_Sabourin
Contributor II
4 years ago

You should be able to pass any dimension/hierarchy as a parameter to the rule to sort anything you want.

  • marisolbritton's avatar
    marisolbritton
    New Contributor III
    4 years ago

    Thanks will give it a shot!  Btw, the BR does work in a quick view.  I tried it. 

  • marisolbritton's avatar
    marisolbritton
    New Contributor III
    3 years ago

    HI again Michel!

    Can I use the same BR to sort on a calculated column?  If so, how do I accomplish that?  Thanks in advance. 

    • Mike_Sabourin's avatar
      Mike_Sabourin
      Contributor II
      3 years ago

      I would imagine so. I assume you want to create like a top ten or sort by value? It would require a bit more work, because essentially you would need to poll every account and get the intersectional cell amount and store the values in memory and return the dimension members based off that data.