Have you wanted to learn how to use MDX to create a VIEW, but are not sure where to start? A great way to learn is by looking deeper into one of your PAW explorations.
The “Edit MDX” button can be used to show the expression associated with your PAW view.
In addition to using the resulting screen to see the expression, PAW allows you to edit the expression … and therefore change your view.
For example, I can update the last line of the expression below to change the EUR result into a USD result.
Not only will this approach help you learn MDX, but it will allow you to easily change the results without having to use the subset editor.
Interested in learning more about using MDX? Watch our webinars:
- How to use MDX in your Planning Analytics Environment, Part 1 (for beginners)
- How to use MDX in your Planning Analytics Environment, Part 2 (for advanced users)
Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.
Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: New Videos
IBM Planning Analytics Tips & Tricks: File Manager
IBM Planning Analytics Tips & Tricks: PAW Process Indent Script Button
