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