Ideas

In case of a lot of if's a case statement makes rules a lot easier to understand and to modify.

Displaying big and complex reports is too slow. Unfortunately almost all customers wants to have a reports showing maximum details... Bottleneck seems to be core.exe, not palo.exe

PALO.EPARENT and PALO.ELEVEL work well if you have only 1 hierarchy within a dimension. But if you have more than one hierarchy it would be great to give a certain root element as parameter and get the parent and or the level in exactly this spec...

A lot of our data processing requires us to do a step in ETL, then in SSIS and then in ETL because ETL can't do things like trigger stored procedures, etc. It would make dataprocessing a lot smoother and easier to automate if ETL could trigger th...

It would be awesome if one could grant users different rights per Frontend (Excel vs Web). In Theory it makes sense to treat them the same (you are either allowed to change a value or you are not) BUT in real life Excel is far more complicated and...

In Jedox Web (Spreadsheet), we can freeze lines and columns. It is very useful when we have to display a long list and we want to keep headers visible on the top of the screen. This feature is not available in Canvas. Having a property to freeze c...

Zero line suppression when selecting 2 dimensions on the rows has been improved in Version 5 whereby it simply hides the rows in Excel but with large extracts this is very slow. We would rather only the combinations that have data are returned wi...

If you are displaying a chart in a Canvas, for example, you can hide the chart, but the frame itself is still visible. This idea is to hide the frame object itself (and all the content in the frame). The rest of the content should then 'flow' as i...

More active feedback from Jedox to suggestions in the feature voting tool would be nice.

In some scenarios, it could be helpful to get a list of distinct attribute values; for example, on a Products dimension with a "color" attribute, return a list of the colors, but each distinct color should appear only once in the result. One possi...