Did you know we have a number of resources available to learn more about MDX? We hosted a two-part series on How to Use MDX in Your IBM Planning Analytics Series. We also published a blog post, IBM Planning Analytics Tips & Tricks: MDX Syntax Explained, to accompany part 1 of the webinar series. 

In part 2 of our MDX webinar series, we demonstrate how to make an MDX dynamic by using the power of Excel.

You’ll see we start with a basic Excel report, generated out of IBM Planning Analytics for Excel (PAx). We then take the static, base MDX and turn it into a concatenation of parts of the index statement and the cell reference. In turn, that enables us to change the root account, thereby changing the data that shows in the report.

Watch the full webinar to learn more about working with MDX.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks on MDX:

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

IBM Planning Analytics Tips & Tricks: Using MDX to Compare Dimension Hierarchies

IBM Planning Analytics Tips & Tricks: Making Default Cube Views Dynamic with MDX