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

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 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 built in the Creating a customer summary OLAP report recipe 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 other ...

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