Excel Add-in Overview

Excel Add-in is a user interface integrated into Excel for managing and displaying the databases stored on the Jedox OLAP server. These databases are Multidimensional OnLine Analytical Processing Databases (MOLAP Databases). All their used data are loaded in the RAM memory of the used hardware. Therefore, the databases work with great speed and high performance.

While Excel itself requires a large number of worksheets to deal with a big amount of data, Excel Add-in organizes and presents data in a way that overcomes the limitations of a two-dimensional Excel table (see How Jedox works).

Excel Add-in is an alternative to expensive software solutions. With Excel Add-in, companies are provided with a tool that enables them to easily display relevant data in a transparent manner. Furthermore, since Excel Add-in is tied to Excel, it is easy to get familiar with.

To install the Excel Add-in you have to download the Excel Add-in setup file. The installation requires an active internet connection. Once the installation is complete, you need to connect to a Jedox OLAP server after the installation with the button Jedox Wizard.

After you have finished one of the installation possibilities, you will receive an additional ribbon in your Excel program:

The description of the ribbon commands is available in Jedox Ribbon in Jedox Excel Add-in.

To create a first view with data from our demo database follow the instructions on Quickstart with Jedox Excel Add-in.

With the button Jedox Wizard you can create a new or edit an existing Jedox OLAP connection.

Under Options Dialog you can change the language of the Excel Add-in commands, the path for log files, your preferences in dialog windows, and much more.

The points above are the most important differences between the user interfaces of Jedox Excel Add-in and Jedox Web. Other important commands on the Excel Add-in ribbon - such as for handling databases (Modeler) or creating reports - are similar to Jedox Web commands.

Updated June 7, 2024