Quickstart with Jedox Excel Add-in

image_pdfimage_print

Installation

  1. Download Jedox software.
  2. Double-click the setup file and carry out the setup with the default settings. After a successful installation of Jedox software (Server and Excel Add-in on the same computer) and restarting Excel, you will see the Jedox Ribbon:

Jedox comes with a demo database that you can use to create a Jedox database view.

Creating a Jedox Database View

  1. Open a blank Excel workbook;
  2. Select the command “New View” in the Jedox Ribbon. This command allows you to easily create Jedox database views on a worksheet;
  3. In the dialog box, select which dimensions and elements you want to see and how they should be arranged;
  4. With drag and drop, move the dimensions from the page area (current location) to the row titles or column titles areas:

  5. Move the dimension “Products” to the row titles area and the dimension “Regions” to the column titles area.

Pasting and Changing a View

  1. Click the “Paste” button. You will get the following view (the value in C11 may differ, depending on the stored demo database values of the current installation):

  2. By using the following techniques you can easily change the view:
    Double-click B11: Expands rows.
    Double-click C9: Expands columns.
    You can change the element of the Month, Years, Versions, and Measures header dimensions by double-clicking on C6, D6, E6, or F6:


Learn more about Jedox Excel Add-in in this free online course from Jedox Academy!

image_pdfimage_print