Excel COM Add-in Overview

Jedox Excel COM 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 COM Add-in organizes and presents data in a way that overcomes the limitations of a two-dimensional Excel table (see How Jedox works).

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

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

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

The description of the ribbon commands is available in Jedox ribbon.

To create a first View with data from our demo database follow the instructions on Paste View Dialog.

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 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 COM Add-in and Jedox Web. Other important commands on the ribbon - such as for handling databases (Modeler) or creating reports - are similar to Jedox Web commands.

For information about the Jedox Excel Add-in system requirements, see Client Environments Supported by Jedox.

Updated December 9, 2024