O'Reilly logo

Microsoft Dynamics GP 2013 Reporting - Second Edition by Christopher J Liley, David Duncan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a connection to cubes

When creating a connection to the cubes, an individual connection must be created for each cube. For example, if we wanted to get information out of our Financials cube and our Sales cube, we would need to create two connections in order to accomplish this.

Older versions of GP offered a Create PivotTable window that could be used from within the Dynamics GP application, to create Excel worksheets with PivotTable reports using data from our cubes. However, there were downsides to using the Create PivotTable window as follows:

  • It required a Dynamics GP license, as a user must be logged into Dynamics GP in order to use the window
  • It did not let us preview the resulting PivotTable

The preferred method, as it was then, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required