Let us know how we can make Jedox even better!
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.
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.