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
Mike_Sabourin's avatar
Mike_Sabourin
Contributor II

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
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.