Book Image

Microsoft Dynamics AX 2012 R3 Reporting Cookbook

Book Image

Microsoft Dynamics AX 2012 R3 Reporting Cookbook

Overview of this book

Table of Contents (17 chapters)
Microsoft Dynamics AX 2012 R3 Reporting Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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 of OLAP and the ability to write Multidimensional Expressions (MDX) queries.

How to do it…

The goal of the recipe is to display the total value of transactions for a customer group represented quarterly in the year 2012:

  1. The first step is to create...