Dynamic MDX: Packing a Punch into One .rdl
Presenter: Erika Bakse
Dynamic MDX can be a great way to reuse, reduce, and recycle .rdls and simplify report maintenance. Have a lot of reports that are practically the same, minus a few pesky exceptions? Dynamic MDX could be the answer! In this session we’ll walk through how to create a basic .rdl that can support a variety of MDX queries that will be generated dynamically. We will also discuss the pros and cons of this approach so that you can make an informed decision of when and if Dynamic MDX is the solution for you.
About the Speaker
Erika Bakse began her business intelligence career two years ago when she joined the Data Inspirations team. She has helped develop training curricula for use of the various SQL Server business intelligence technologies and is a contributing author of Microsoft SQL Server 2008 Reporting Services Step by Step (Microsoft Press, 2006). Her blog is available at erikasblog.datainspirations.com, and she tweets as @BakseDoesBI