Implementing Jet Enterprise: Deploy and Execute OLAP Cubes

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

In the last post, I showed how to deploy and execute the project; in this post, I am going to deploy and execute the OLAP Cubes which will make them available for reporting. For a detailed description of the deploy and execute process, see the Jet Support article. The deploy and execute can be done separately, but for the first deploy and execute during implementation, I'd tend to do them together.

In this stage we want to deploy and execute the entire OLAP Cubes. To do this, click on the Cubes tab, then right-click on the OLAP Servers top level node and click Deploy and Execute:

Jet Data Manager Server: Deploy and Execute

Ensure both the Deploy and Execute checkboxes are marked and click Start:

Jet Data Manager Server: Deploy and/or Execute

Enter a Version note and click OK:

Jet Data Manager Server: Version Details

Review the tasks and click Start to begin the deploy and execute process. Once finished, as shown by the progress bar reaching 100% without displaying errors, click Close:

Jet Data Manager Server:

The OLAP Cubes have now been created and populated, so we can now test that everything is working by connecting Excel to the cubes.

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 *