Before you can create a Data Source connection, you must first download and install the Jet Excel add-in from the Jet Global download website.
An OLAP Cube database must have previously been created with the Jet Data Manager. You will need login permissions for that database. You may need to contact your system administrator to create that for you.
You’ll also need the following files and information:
- Your Jet License Activation Code (including a Universal Connector license)
- Database Information:
- Server Name or IP Address
- Database Name
Intro to PivotTables for Cubes
Accessing Cubes within Azure
To create a new data source connection to your Cubes, start by selecting Data Source Settings from the Jet ribbon.
On the Data Source Settings window, click the Add button.
On the New Data Source window, provide a name for your data source and select Cube for the type. Click OK.
On the Authentication tab, specify the Windows account that can be used to access the OLAP database.
If the server recognizes your Windows login, you can select the Current User option.
If access to the OLAP database is needed with a different Windows user account, you will need to create an Internet-Based connection, as detailed in the following article: Create An Internet-Based OLAP Cube Data Source With Jet Reports
On the Connection tab, enter the server where your OLAP database is located.
In the database drop-down, you will find the name of your OLAP database. If the drop-down does not populate, the Windows login you are using does not have access to the Cubes. If this is the case, see the knowledgebase article referenced at the bottom of this page.
You can then click the Test Connection button and should see the Test Connection Succeeded message.
If you would like this data source to be the default data source that the Jet Excel add-in will use, click the Set Default button.
Click OK and your Cube data source is now ready for use with Jet Reports.
When the connection has been successfully added, the Pivot Table button will be available on the Jet ribbon.