Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
Implementing Jet Enterprise: Connect Microsoft Excel to the Jet Enterprise Cubes
May 29th, 2018 by Ian Grieve
This 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:
In the Data Source Settings window, click the Add button to add a new data source:
Enter a Name and set the Database Type to Cube and click Add:
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:
Click OK to save the changes and create the data source. To use the cubes, click Pivot Table:
Select Jet Cubes and select the Finance cube and click OK:
The PivotTable can then be put together in the usual way:
|Implementing Jet Enterprise|
|Create Project Repository|
|Deploy and Execute the Project|
|Deploy and Execute OLAP Cubes|
|Connect Microsoft Excel to the Jet Enterprise Cubes|