Sort cube view rows alphabetically based on member name

[AndreaF]

Hi,

I know I could create a custom member list of an XFBR rule for the scope, but is there an easier option to get the cube view rows ordered alphabetically based on member names? Eg. currently, if I have E#Ent1000.Children in row, the cube view is by default showing the members children of Ent1000 in the order with which they appear in the Entity hierarchy. I would like them to be ordered based on their name.

Thank you

[MikeG · Accepted solution]

Hi @AndreaF , the only way I've accomplished this is using the Finance rule and function from GolfStream: 

Otherwise it is as you noted, dimensional member order based on the DImension Library.  Unless you created an alternate hierarchy that was alphabetical and added that to the maintenance and management of the metadata.

Hope this helps,

[AndreaF]

Thank you @MikeG. I've ended up writing an XFBR rule for it.

[RobbSalzmann]

Hi @AndreaF If you need some code...
Re: How can I use a Business Rule to sort a Member List in alphabetical order? - OneStream Community...