the design of the method value() in the macro engine should be improved. It returns a different type depending of the arguments passed to the range() property. Example: activesheet()->range('A1')->value => returns a string // this is corr...
Weighted Average option for mutiple element POV selection in pasteview
Jedox currently displays a straight average in a pasteview report when we select multiple element in a dimension. However it would be useful to have weighted average option that the report can display . In the below example we attempted to use mul...
Allow pasting array formulas in Macro Engine, using a method "FormulaArray" like in VBA, e.g.: activesheet()->range('D3:G3')->formulaArray = "=TRANSPOSE(C4:C7)";
More user guidance when using rule templates with list result in Rule Editor
Some query types for rule templates return a list of elements, for example the query "Dimension element like (list)". Variables with a list result can only be used in specific places in rules and require correct syntax. However, the Rule Editor st...
When setting formats in modeller on a dimension, could we set a default format for all items and then adjust from there? In Jedox 2020.1 we have element formats. It would be great if we could set a 'default' number format and cell styles that is a...
Since chromebooks / pixelbooks are becoming popular, make jedox compatible with Chrome OS. Currenlty jedox is very glitchy in pixelbooks e.g. not able to scroll Thanks
Currently the powerbi integrator can only create 1 table in a dataview, making it essentially useless. Even though API-PUSH datasets are difficult to work with, if you at least had the ability for multiple tables, and some control/setting of the d...
We have major frontend performance issues, which stems from the HIDEROW() and HDECOLUMN() functions are not performing well. However, with the current Jedox functionality, these are key to nice UI, so increasing performance would really help out.
Function / rules feature that allows to retrieved saved db value in rule determined cell
I would like a function or rule feature that allows to retrieved saved db value in rule determined cell. Use case is like having a cell calculated unless somebody enters an alternative value. This would allow us to avoid having another measure for...
In SQL we have a lot of nice functions to handle null. A very nice example is ISNULL() gives you the possibility to return and altenate value when the value is null, and if not null then it returns the value you are evaluating.