Page 1 of 1

Sorting consolidations dynamically

Posted: Mon Jan 21, 2019 6:04 am
by kaazimraza
Hi everyone,
I am trying to sort the following consolidations ;
Capex-projects-consol-sorting-issue.png
Capex-projects-consol-sorting-issue.png (3.01 KiB) Viewed 2597 times
I want 'All Not Used' to be listed before 'All New Work', and I have tried variations of DimensionSortOrder function but I am not having any luck, certainly I am doing something incorrect.

What's the best combination of parameters to sort it in a way that that I get All Not Used between All Current Projects and All New Work?

Thanks
Kaz

Re: Sorting consolidations dynamically

Posted: Mon Jan 21, 2019 8:22 am
by Wim Gielis
In the Dimension Editorovw the elements in the correct order. Then set the order of the indexes by clicking the last icon of the menu bar.

Re: Sorting consolidations dynamically

Posted: Mon Jan 21, 2019 1:52 pm
by tomok
Wim Gielis wrote: Mon Jan 21, 2019 8:22 am In the Dimension Editorovw the elements in the correct order. Then set the order of the indexes by clicking the last icon of the menu bar.
This only works when you intend to maintain the dimension manually. If it is maintained by TI this will not work. Realistically, it's not practical unless these top two levels never change. Make the sort order on the dimension By Element. In your TI attach All Current Projects, All Not Used and All New York as children of All Plan Projects, in that order, in the Prolog. Build the rest of the hierarchy in the Metadata tab, taking care to skip any steps that would attempt to attach these specific children.

I have done this on several occasions and it will work but the structure has to be pretty static.

Re: Sorting consolidations dynamically

Posted: Fri Feb 08, 2019 10:35 am
by kaazimraza
Thanks Wim and Tom.

@Wim, I tried setting order of the elements, but they get blown away as soon as the overnight process loads data and re-assign children to their respective parents.

@Tom, my data loading process has multiple processes. I am adding Current, New Work, and Not Used as children of All New Projects in the Prolog of the master process, but then I have another process to load Current jobs, another one to work New and Not Used where jobs are being assigned between New Work and Not Used.

So I guess, fair to say, it's not a very static hierarchy.

And I appreciate your quick response, and apologies for the delay in getting back.

thanks

Kaz

Re: Sorting consolidations dynamically

Posted: Fri Feb 08, 2019 1:17 pm
by PavoGa
If you can use subsets to control display, use a numeric attribute to control the display order.

Otherwise, as Tom states, you have to set dimensionsortorder to ByInput and then carefully control how objects are added.