Processing speed for embedded palo.eprev or palo.enext functions within rules are very slow especially when more than one function exists in a rule. For demographic modelling where age in the current year depends on age(-1) in year(-1) the time to...
Action Button - Integrator Job variables via cell range (e.g. as in AFilter)
The new action button feature provides the possibility to start an integrator job and define ETL variables dynamically. Instead of choosing each variable value it would be much easier to choose one named range which contains two columns, first con...
Sometimes you need to have a list of values to iterate on, for instance in a loop job. A constant table is used for this purpose. This would be great to be able to populate a constant table with variable values (like an array), coming from a diffe...
We currently have zero suppression, but I would like to propose suppress blank/null, so that summations is not suppressed even if the sum total is zero. Currently I can easily miss data that sums to zero
Expose the PHP functions in the spreadsheet functions
for instance I want to compare 2 ranges, I have a function: function arrayintersect($array1,$array2){ return array_intersect($array1,$array2);} this would be helpful if the array_intersect function would be directly accessible from the spreadsheet...
Dynarange --> control expand/collapse more dynamically (for each node individually)
Currently you can only control the initial expand/collapse of dynarange nodes by level -> e.g. expand whole dynarange up to level 3 . It would be great to set the initial expand/collapse state more individually for each element. . like this: . ...
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...