Cube View Sorting

[LKabbaj]

Source:   Migrated from Champions

Hi All,
This is my first time posting and happy to do that!
I’ve built a cubeview showing the clients in rows and Revenues in columns but struggling to sort my client based on the revenues (descendant).
Is there any effective way to apply descendant / ascendant sorting ?
Thanks

[MikeG]

Hi Lotfi, you need a Finance BR for the ranking logic. There is an example in GolfStream.

image.png710×421 38.3 KB

Take a look at the Row definitions and you can see the syntax on how to call the Business rule and also the Finance BR name that has the sort/rank logic and example.

[rhankey]

Take a look at OS’s Finance/XFR_MemberListRanked business rule that I believe is included in GolfStream, which returns ranked/sorted lists of members. You may need to modify it a little to do precisely what you need, but it has working code elements for what you are asking.

[LKabbaj]

Much Appreciated dear Robin, that’s great !
Thanks for your clarifications !

[LKabbaj]

Much Appreciated dear Michael, that’s great ! Would love to have this feature as “standard” meaning with no Business rule in future releases, do you know if OS have Something planned in the pipe ? in other CPM platform, it’s just a click, like Excel…
Thanks for your clarifications !