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 for the year. Modify the query as shown in the following code snippet to parameterize the hardcoded values:

   SELECT {[Measures].[Accounts receivable amount - transaction currency]} oncolumns, 
   nonempty(
   [Transaction date].[Quarter].[Quarter].Members*...