The concatenate.range function is awesome! This would be even more awesome to have the opposite, say, "split.range", that would allow splitting a string regarding a delimiter (like PHP's explode(<string>,<delimiter>). This would return...
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...
Currently we have a very complex model that is depending a lot on the SVS server. But we noticed that with the amount of interaction between the spreadsheet and SVS server sometimes the SVS server "freezes". In order to solve this we must restart ...
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
I would like to propose being able to make user defined queries for rule templates. I'm thinking exposing it from the integrator which could generate the query, and then expose the result to the rules engine. This would create a much more flexible...
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...