sort by ascending order of values NR in column B in Cubeview?

[Davy]

OneStream is the best EPM app for consolidation and everything planning - it is going to kill Hyperion / Essbase !!

Does anyone have a sample business rule BR for sorting rows in a column based on values in a column.  e.g. in screen shot, I want to sort by ascending order of values (NR) in column B  in Cubeview?

I probably have a written something similar long time ago, but would like to see if someone else wrote a better BR.

[Davy]

[NicoleBruno · Accepted solution]

Hi Davy, 

I'm trying to do min/max calcs and have been directed to a KB article and details in GolfStream which (if they work) might solve your issue too. I can't seem to figure out how to attach a file so maybe sent OS support a ticket and ask for "Title: How to use XFR_MemberListRanked to sort rows". It's not an official knowledge base article on the OS website so I can't send a link either but it documents instructions on using XFR_MemberListRanked which is also in GolfStream. 

Honestly I haven't gotten it to work yet but it seems like it should solve both of our issues. 

[Koemets]

It's a simple XFBR rule really, where you order the result set.

[MarioGV]

Hi Koemets; could you please share the XFBR rule? I've the same issue but don't know the brapi to select the amount and sort it.

Kind regards.

Mario GV