07-03-2023 10:55 AM
Hello - I am working on a cube view where I would want the resulting values (variance amount) to sort with the highest value first. The complication is, my users are used to reports from Hyperion that enabled expansion drilldowns on these members. The Hyperion reports retained the sorting even when using expansion. I can't seem to figure out how to do this in OS - or if it is even possible - when selecting a member expansion (.Tree or .Base).
Wondering if anyone else has attempted this.
Thanks,
Cody
07-05-2023 12:56 AM - edited 07-05-2023 12:58 AM
I don't think you can achieve this in CubeViews, but it might work by leveraging Pivot Grids. Here is what I would suggest:
Alternatively, you can pull the whole CubeView (fully expanded) in an Excel sheet, and then manage your data fully there (displaying it in another sheet), which gives you a bunch of other options.