O'Reilly logo

Microsoft Dynamics GP 2010 Reporting by David Duncan, Christopher Liley

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 the 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.

Dynamics GP 2010 does have a Create PivotTable window that can be used from within the Dynamics GP application to create Excel worksheets with PivotTable reports using data from our cubes. However, there are downsides to using the GP 2010 Create PivotTable window:

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

The preferred method is to simply use Microsoft ...

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