Who is it for
End Users and Developers
Duration
8 hours
Difficulty
Intermediate
Prerequisite
End User (PAW)Next Course
MDX Fundamentals
When retrieving a list of members in a dimension or analysing cube data, IBM Planning Analytics utilises the language Multidimensional Expressions (MDX) to query the TM1 Server. There is an advantage in understanding how to read and write MDX for end users, as it will provide extra controls to enhance report building in Excel and dashboards in Workspace. With this course, you will learn:
- 1. How to read the MDX syntax
- 2. How to filter the dimension to return a list of members
- 3. How to get a member’s attribute
- 4. How to sort members
- 5. How to combine sets
- 6. How to get a cube’s view
- 7. How to apply an MDX to IBM Planning Analytics for Excel
