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 ad-hoc reports

With our basic knowledge of PivotTable, creating reports is actually quite simple and can be very fun once we get started. It's an experience similar to opening presents on Christmas morning; you don't really know how cool your report will be until you start playing with the different measures and matching them with different dimensions. An easy report to start with and get an idea of the power of Analysis cubes for Excel, is a simple one that uses the Accounts by Category dimension, the Signed Amount – GL Trans measure, and the Periodicity dimension as the columns.

To accomplish this, we will use what we have learned in earlier sections to create a new data connection or use an existing connection. Once we have made our ...

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