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...
Translation: use default language in reports if system language not available for reports
Currenty if adding the feature multilanguages we has two possibilities: 1) Using the following formula: =PALO.DATAC(rngDB;"#__Translation";"Name";"1000130";rngLanguage) I translate the text in german and french. My default language is english. If ...
a warning that would inform that generated rules (from rule templates) have been deactivated (due to syntax errors, or missing elements for instance) would be really helpful