We would like to filter on two different attributes of a dimension by using named ranges. In the attribute tab of a subset, it would therefore be great to have the option to add multiple filters (as it is already possible in the hierarchy, picklis...
Not rebuilding and collapsing a dynarange after choosing other options in comboboxes
We have received feedback from many clients that this setting makes the budgeting process significantly less user-friendly. For example, the drill-down setting in the PnL account dynarange is set to 2 to prevent a very long list when opening the i...
Simple conditional formatting when a cell is rule or consolidation based.
Clients often ask if we can highlight which cells can be entered into and which cannot. Of course we can work around this, but if there is a large table of details (say in a Dynarange) it adds a lot of workings to the sheet. It would really help i...
Jedox Excel Addin for Office 365 (connection issue) or option to remove
Hi, I couldn't find any article on how to remove the Office 365 addin once it is installed. It always loads with Excel. There is a KB on uninstalling the old addin but there is nothing for the new addin. I am an Independent consultant and have my ...
Excel Add-In - Variable for connections in formulas
At the moment I need to adapt all formulas I create in Jedox manually when I want to switch between the connection to our dev and live instance. It would help if the Excel Add-In would directly enable a variable as an input for a connection e.g. i...
Add paging in reports for Legal Entities (including the ones listed for workflow)
Sometimes, there are many Legal Entities at customers, paging function would be needed in reports: "Scope of consolidation", "Data collection", "Consolidation Manager", "Consolidated Financial Statement".
We have a lot of templates which often use the same macros. It would be great to have the possibility to have this code in one place instead of having the same code over and over again in every template. This would speed up development and make ma...
PALO.DATA.SOURCE Identify rule-based values/cells
Function to identify, if a value is calculated or stored in the database.
This enables dynamic reports where a conditional formatting opens cells for data entry ONLY if they are actually stored an...
Custom source level elements in the Consolidation dimension
The Local GAAP element of the Consolidation dimension is the only element to receive original source data for the separate financial statements. This data is captured on the ~ element of the Scope dimension and shows automatically on all other sco...