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

Utilizing the Excel cube formulas

In our last section, we explored creating Analysis Cubes reports by using the PivotTable functionality in Excel. For those of us who have used Excel's PivotTable functionality, it is a powerful tool that allows for effortless ad-hoc data analysis. When combined with Analysis Services, PivotTables can provide users with an unparalleled ability to peruse aggregated data and drill-down to the underlying data quickly and accurately.

But, for all of its usefulness, some drawbacks do exist for using Excel PivotTable functionality to access data in an Analysis Services database.

First, it's difficult to combine PivotTables in a worksheet containing other PivotTables or Excel objects such as charts and graphs. The dynamic ...

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