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

May 29th, 2018 by

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:

PivotTable

Click to show/hide the Implementing Jet Enterprise Series Index

2800

Read original post Implementing Jet Enterprise: Connect Microsoft Excel to the Jet Enterprise Cubes at azurecurve|Ramblings of a Dynamics GP Consultant

Source: azurecurve

Leave a Reply

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