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

Excel Pivot Table-Analysis Cubes Interface

For those of us familiar with Excel PivotTables, this next section will be familiar; however, be sure to pay close attention because we'll point out some of the differences between PivotTables that use a standard dataset—such as a table in another Excel worksheet—versus PivotTables that use Analysis Services as a data source.

The next image shows us some of the features of Excel PivotTables that we will cover in this section:

Excel Pivot Table-Analysis Cubes Interface

PivotTable pane

When we first create a connection to our cube, our Excel worksheet is transformed into an Excel PivotTable. The most immediate indication of this is the PivotTable pane ...

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