The following steps describe how you can create Pivot Tables in Microsoft Excel 2007/2010 using the Jedox ODBO Provider. From the Data menu, select “From Other Sources→From Data Connection Wizard”: Select Other/Advanced and click “Next”: Choose your Jedox ODBO Provider from the list and click “Next”.
Enter the IP address of the machine with the main Jedox ODBO Provider.
|Username||Standard user name is “admin”.|
|Password||Standard password is “admin”; be sure to change this to a secure password.|
|Enter the initial catalog to use|
(After the ini-changes, described in the previous subsection, the “main” Jedox ODBO Provider knows the location of the Jedox Server with the data).Choose the database to use and test the connection. If this is successful, you can click OK. In the next dialog you can choose which Cube you want to query (if more than one is present): In the next step you can enter a file name for the connection data, a description and a friendly name. You have the option to save your password in connection file: If password saving is selected, you will be warned: Then click on “Finish”. Final steps should look like this: Finished Pivot table in Excel 2007/2010: