Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
12 months ago

Sort cube view rows alphabetically based on member name

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

Cube View
  • MikeG's avatar
    MikeG
    12 months ago

    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,