After downloading the Jedox software, double-click the setup file and carry out the setup with the default settings.
After a successful installation of the Jedox software (Jedox Server and Jedox Web on the same computer), you can access Jedox Web and log in at http://127.0.0.1/ui/login/. The address must match your installation.
To start Jedox Web, go to Start > Programs > Jedox > Jedox Web, using the credentials admin/admin.
Click on Report Designer > New > New Spreadsheet to create a file called “Test1”. Double-click the new file to open it.
You will notice immediately that the format of the Jedox spreadsheet is identical to the widely used spreadsheet programs Microsoft Excel and OpenOffice Calc.
Jedox comes with a demo database that you can use to create a Jedox database view.
Creating a Jedox database view
After creating a new spreadsheet, place the cell pointer in A1 and select the command Query > Paste View … This command allows you to easily create Jedox database views on a worksheet.
A dialog box opens where you can select which dimensions and elements you want to see and how they should be arranged.
You can drag and drop the dimensions from the page area (current location) to the row titles or column titles areas:
Move the dimension Products to the row titles area and the dimension Regions to the column titles area.
Pasting and changing a view
Click the “Paste” button and you will receive the following view (the value in C7 may differ, it depends on the stored demo database values of the current installation):
Using the techniques described above, arrange the following view (the shown data values may differ, they depend on the stored demo database values of the current installation):
This article demonstrates how simple it is to display the data from a cube and change an existing view in a Jedox Spreadsheet.
For more information, check the Jedox Training Courses: http://jedox-academy.eventbrite.com