Define a separate cube data value for dynarange filtering and sorting
With a dynarange, you can only filter based on the value used for data filtering. If you have e.g. Projects as a vertical dynarange and turnover and costs as a horizontal dynarange, and want to filter out elements where both are 0, you cannot then...
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 ...
Provide support for creating Tornado, and Funnel Charts: various types, often used with sales funnel data. Please review the attached mockup for reference.
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.
Sort rows by value in Drill Down by / Drill Anywhere
When performing a Drill down by / Drill Anywhere, the dimension I chose is spread out in the order that is part of the dimension. It would be helpful if the dimension would be sorted by their values (if original cell is a negative value, ascending...
When planning functions such as splashing or copy are used, the audit trail does not keep a complete record of what has been entered.
For example, executing the following command “copy Actual;2023” only records the following NUMERIC_VALUE: 12345,...
Action button for Integrator to include option for dialogue box
Dialogue box will allow users to define variables prior to running the job. Action options will have to allow for the selection of variables to be shown so not all appear.
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