Quickstart with Jedox Excel Add-in

image_pdfimage_print

Installation

  1. Download the Jedox software.
  2. Double-click the file “Jedox_2018_2.exe” and carry out the setup with the default settings. After a successful installation of the 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 “Paste 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 receive the following view:
  2. Using the techniques described above, arrange the following view:

This article demonstrates how simple it is to display the data from a cube and change an existing view in an Excel worksheet using Jedox.

Learn more about Jedox:

Jedox Training Courses
more at http://jedox-academy.eventbrite.com

image_pdfimage_print