Version Blending / Forecast Splashing: Centralized HOLD
I would like to be able to manipulate "HOLD" using rules and Integrator. Currently the users needs to use the Planning Assistant / right click in UI. But general hold is needed for Forecast scenario's like 3+9 to ensure splash works correctly, and...
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...
Allow pasting array formulas in Macro Engine, using a method "FormulaArray" like in VBA, e.g.: activesheet()->range('D3:G3')->formulaArray = "=TRANSPOSE(C4:C7)";
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
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.
New splashing command that factors in calculated values
I think it would be useful to add a new splashing command that factors in the existing calculated values already in the intersections being splashed on. This would allow splashing on version blending to work properly out of the box as well as bein...
Make Data Validation on Cells Ignore PALO formulas in Cells
When we are working on a model and make a change like adding a dimension to a cube all the PALO formulas need to be updated to reflect any changes including the underlying cell formula where you have data validation on top of. When you try to upda...
Change the current excel cell comment function so it stores the comment in the measures dimension for example. This would allow an end user to enter comments on a cell by cell basis (just like excel) without having to develop a custom solution. Th...