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.
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.