Extend the storage to capture reporting positions for the notes (text narratives and tabular information) which cannot be captured by the existing cubes. Provide sample data and reports for the most common notes sections.
Users would benefit from an easy way to set up custom data validations, similar to the setup of consolidation rules. E.g. the amount on a PnL Account needs to match a movement on a BS Account.
Have something like a dynarange also available for Canvas frames would enable me to configure several objects (eg. KPIs) much quicker. I could define a KPI layout which would be the same for all, but the metrics displayed in each individual KPI wo...
Include "Column Exclude pattern" into Table View Transformation
Many times, a Table View Transformation is the final step of loading data into different sources. It would therefore be very handy to also have the Column Exclude/Include patterns in this transformation. This way, you don't have to define the whol...
When there's an error in one of the columns due to a wrong format or null values in some cells, the Excel Extract will not load and instead return an error. An option to either ignore the format of columns or ignore columns entirely, if they're no...
Being able to align components to grid and other components
Having a function like in Power Point and Power BI, where you can align boxes, charts, tiles, components etc. to each other. Should come with a visible indication of alignment and "magnetic" behavior.
There's often a significant number of databases present in a Jedox environment, with possible several people working on them and several usecases. To allow keeping track of what specific databases are used for, who works on them etc., it would be ...
Basically expose in the macro engine all what is possible to do in a spreadsheet: - create / rename / delete / hide / show sheet - insert / delete columns/rows - you name it
Show Dimension-Name in palo.data-function in web reports
When one is inserting the palo.data-function in Excel, the function shows always the name of each dimension followed by the default element; so the user can easily identify the dimension to change the reference value. By inserting the palo.data-fu...