O'Reilly logo

Microsoft Dynamics AX 2012 R3 Reporting Cookbook by Deepak Agarwal, Chhavi Aggarwal, Kamalakannan Elangovan

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 customer summary OLAP report

Online Analytical Processing (OLAP) helps create interesting data mash-ups that can show trends, distribution, and various other dimensions summarized for top-level management. Dynamics AX offers many different ways to represent OLAP reports, such as SQL Report Builder, Power View, and Excel. But when it comes to exposing the reports over the Web or deploying them to a role center, then SSRS reports are an ideal choice. In this recipe, we will get into the details of creating a simple OLAP report that will summarize the total transaction value across customer groups quarterly in a year.

Getting Ready

To be able to implement this recipe, you need OLAP configured for Dynamics AX. You must have a basic understanding ...

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