Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

ADD A NEW IDEA

Microsoft Office integrations (Excel, PowerPoint, & Word)

Showing 42

Excel Data Driven Modeling - Ability to store column names (with suffixes) in new spreadsheet/clipboard

Scenario: An excel spreadsheet data (with 10+ columns) is used in Data-driven modeling with original column names. A lot of time and effort is spent on drag/drop the columns as hierarchy or attributes or measures or drill Issue: The new column nam...
over 2 years ago in Jedox Platform / Microsoft Office integrations (Excel, PowerPoint, & Word) 0 Future Consideration

Validate name field when Exporting xlsx from Excel to Jedox Web Report designer

Currently, when exporting an xlsx file from Excel to the Report designer using the COM add-in. The name field in the dialog is by default empty, if the user clicks export without entering a name, the process starts loading but then nothing happens...
almost 3 years ago in Jedox Platform / Microsoft Office integrations (Excel, PowerPoint, & Word) 0 Future Consideration

Google Sheets Jedox Add-in

More and more clients seem to be leveraging Google sheets instead of Excel. Anaplan is pursuing this strongly, and we need to consider making this an option as well.
about 3 years ago in Jedox Platform / Microsoft Office integrations (Excel, PowerPoint, & Word) / Other 0 Future Consideration

Creating a Excel Add-in connection from Jedox Web

To improve the On-Boarding of the Excel Add-in, we could add the possibility to create Excel Add-In Connections using Jedox Web. E.g. in the Info Menu of Jedox Web, there should be a link that when clicked opens the Excel Add-In and creates the co...

Action Buttons in Excel

the new actions capabilities in combo boxes are very powerful. We should have a similar capability to add a Jedox Action button in Excel. This button at the very least should allow the kicking off of an ETL process. Lots of other things possible a...
about 3 years ago in Jedox Platform / Microsoft Office integrations (Excel, PowerPoint, & Word) 0 Future Consideration

Excel - allow multiple accounts per connection

When using Excel and debugging user rights it will be helpful to switch between several accounts without having to change the connection name. The reason is that people will send you their own Excel files and often hardcode the Connection in vario...
over 3 years ago in Jedox Platform / Microsoft Office integrations (Excel, PowerPoint, & Word) 0 Future Consideration

Refactor PALO.SETDATA_BULK

PALO.SETDATA_BULK allows dramatic optimization when loading cube cells. Still the way the coordinates have to be passed to the function is not very convenient because they all have to be organized in a tabular way. A possibility to pass different ...
over 4 years ago in Jedox Platform / Microsoft Office integrations (Excel, PowerPoint, & Word) 0 Future Consideration

Add ability to Influence which sheets are included in XLSX snapshot

The export of the whole workbook should then be the non-default option. A common use case is to export the single sheet that you are on. Would be good to have an option for sheets to exclude/include them from snapshot export.

Hide all #VALUE errors

Especially on opening or reloading a workbook for a short moment there may be displayed lots of #VALUE errors, while Jedox is retrieving data. Only possibility to hide these currently is an optional formatting for text color to match background co...

Option to set alias as default value

It should be possible to preselect the alias as the default value to avoid confusing users with IDs defined as base elements. The setting should be made user-specific.