Skip to main content
A
AndreaF
January 4, 2024
Solved

Sort cube view rows alphabetically based on member name

  • January 4, 2024
  • 3 replies
  • 0 views

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

    Best answer by MikeG

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

    MikeG_0-1704376784856.png

    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,

     

     

    3 replies

    M
    MikeGAnswer
    January 4, 2024

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

    MikeG_0-1704376784856.png

    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,

     

     

    A
    AndreaFAuthor
    January 4, 2024

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

    Terms & ConditionsAccessibility statement