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 (Jedox Server and Jedox Web on the same computer), you come to the Jedox Web Login at http://127.0.0.1/ui/login/ (address must match your installation).
Start Jedox Web with “Start – Programs – Jedox – Jedox Web”, using the credential “admin” for both Username and Password.
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.
2 CREATING A JEDOX DATABASE VIEW
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.
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 and you will 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 a Jedox Spreadsheet.
LEARN MORE ABOUT JEDOX:
JEDOX Training Courses
more at: http://jedox-academy.eventbrite.com