O'Reilly logo

Microsoft Dynamics AX 2012 Reporting Cookbook by 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

Adding a parameter lookup for OLAP

The previous recipe was a simple implementation of a static MDX query; this recipe will further extend it to influence it through parameters. We will parameterize both transaction year and company under the where condition. Users will be able to do a lookup for these parameters that are again attached to MDX queries.

Getting ready

To be able to implement this recipe you need the OLAP configured for Dynamics AX. You must have a basic understanding of OLAP and the ability to write MDX queries. This recipe extends the report build through the recipe Creating a customer summary OLAP report in this chapter.

How to do it…

  1. The MDX query used in the existing report has two conditions hardcoded; one for the company and the ...

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