Implementing Jet Enterprise: Connect Microsoft Excel to the Jet Enterprise Cubes

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Enterprise sub-series.

With the basic Jet Enterprise installation and configuration now complete, Microsoft Excel can be connected to the cubes to test that everything is working as it should; launch Microsoft Excel, select the Jet tab and click the Data Source Settings button:

Microsoft Excel

In the Data Source Settings window, click the Add button to add a new data source:

Data Source Settings

Enter a Name and set the Database Type to Cube and click Add:

Add Data Source

When returned to the Data Source Settings window, click the Connection tab in the left pane.

Enter the full SQL Server Instance name in the Server field and select the JetGpOlap database in Database field:

Data Source Settings

Click OK to save the changes and create the data source. To use the cubes, click Pivot Table:

Microsoft Excel - Jet Pivot Table

Select Jet Cubes and select the Finance cube and click OK:

Insert PivotTable

The PivotTable can then be put together in the usual way:


Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) –
Your Email (required) –

Leave a Reply

Your email address will not be published. Required fields are marked *