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.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

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