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:
The first step is to create...
