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

Excel PivotTable – Analysis Cubes interface

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

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

Excel PivotTable – Analysis Cubes interface

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

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