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...
It would be useful to have a setting option to activate audit for all cubes and database. Especially for customers where audit is a requirement, it is easier if this setting can be checked instead of having to remember to set the audit for all cub...
We want to prevent us admins from deleting a lot of data via the Excel Add-In. Therefore we wanted to create an admin_excel role which has the same rights as the admin role, but an R for to the cell data Excel right. But this is not possible as on...
As a Private Equity company, XIRR is our basis for performance analysis. We can use a spreadsheet function to calculate XIRR and NPV but the spreadsheet limits my reporting capabilities. I have more than a hundred companies with several classifica...
I wonder if the Delete Cube button can be moved to the far right, making it the last button accessible. Recently, I accidentally pressed the Delete button instead of the Clear button and ended up losing all my day’s work. This was incredibly frust...
Splasher to write into first base child of the element
It will be good to have a splasher option to writeback at the first base element of each parent element. This will save the cube filled up with too much data. Sometimes it is necessary to allow writeback at total level but it is not good to splash...
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".