01-04-2024 05:38 AM
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
Solved! Go to Solution.
01-04-2024 09:01 AM
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,
01-04-2024 09:01 AM
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,
01-04-2024 12:34 PM
Thank you @MikeG. I've ended up writing an XFBR rule for it.
01-04-2024 01:57 PM - edited 01-04-2024 02:03 PM
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...