Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories In-Memory DB
Created by Guest
Created on Sep 1, 2021

Dimension upload should save the weight of the elements for "Full hierarchy" format.

Currently, the weight of the elements will always be set to +1 after uploading an Excel file into the dimension, regardless if you set a different weight for those elements prior to uploading. This behaviour is encountered when using 'Full hierarchy' as Format type when downloading the dimension. In Dimension upload, setting the weights is not supported for "Full hierarchy" format. In "Parent child" format the weight can be set. The reason is that here it's easier as there is only a single weight column necessary for all nodes.
It would be nice to have the possibility for the weight to be saved even when using 'Full hierarchy' format.

  • ADMIN RESPONSE
    Nov 25, 2021

    Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.

    UI-wise it would be overwhelming to users when weights must be selected in the upload of a dimension in full-hierarchy. You can set the weights from a file that includes a full hierarchy via Integrator using a full hierarchy transform and dimension load. An Integrator load also comes with the advantage to save some clicks for this kind of repetitive task.