ETL/Report search from cubes/dimensions in Modeler
We would like to know which cubes/dimensions are referenced in which ETL/report in Jedox Web so that they could quickly identify which cubes are used and thus can be modified if we modify cubes/dimensions.
Transpose (interchange) rows and columns in the dimension editor of the Modeler
Some dimension have more attributes then elements. In these cases it would help to transpose/ interchange between columns & rows in order to make more values fit on one page. Having e.g. all values on one screen would help to get a faster &...
Expand Default value of attributes to further components of the Jedox plattform
The functionality to set Default values for dimension element attributes (currently available in the Modeler) should be also available
a) when uploading a dimension from a file with the Modeler,
b) when loading a dimension with Integrator,
c) ...
Expand Domain constraints for attributes to further components of the Jedox plattform
The functionality to constraint attribute values via a Domain (currently available in the Modeler) should be also available
a) when uploading a dimension from a file with the Modeler,
b) when loading a dimension with Integrator,
c) when enteri...
Rework formatting for dates, thousand/decimal separator and percentages in Jedox Web
Regarding the formatting I like to suggest a change request:
1) For dates: just follow the formatting of the cell for as well OUTPUT as INPUT. The same as Excel does. Now we have the situation in Jedox web that the input of dates must be in the la...
Form elements should keep their position when inserting/deleting columns or rows
we defined a layout where (e.g.) comboboxes have a certain length and position. we created a template with some predefined comboboxes we use in nearly every report. However, when I have to insert a new column the comboboxes are shifted to the righ...
in SAC there is the possibility to create such a rule:
[Marketing Cost] = [Revenue] * [Marketing Cost % of Revenue] | INVERSE ( [Marketing Cost % of Revenue] := [Marketing Cost] / [Revenue] )
it allows you making Marketing Cost % of Revenue and ...
implement the new XLOOKUP function in Jedox Web. The function is present in the latest versions of Excel and does the same as VLOOKUP but more powerful