<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

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

Interested in enrolling?