Quickstart with Jedox Excel Add-in

image_pdfimage_print

1 Installation

After downloading the Jedox software, double-click the file “Jedox_7_0.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.

2 Creating a Jedox Database View

 Open a blank Excel workbook, and then choose the command “Paste View” in the Jedox Ribbon. This command allows you to easily create Jedox database views on a worksheet.

In the dialog box you can select which dimensions and elements you want to see and how they should be arranged.

With drag and drop you can move the dimensions from the page area (current location) to the row titles or column titles areas:

Now move the dimension “Products” to the row titles area and the dimension “Regions” to the column titles area.

3 Paste and Change a View

Click the “Paste” button to receive the following view:

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
Was this post helpful?
NoYes (+3 rating, 5 votes)
Loading...