Who is it for
End Users and Developers
Duration
8 hours
Difficulty
Intermediate
Product
IBM Planning Analytics Workspace
End User MDX (PAW)
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 learning this course? Choose the enrolment option that suits you
Single Course | Power User Membership | Enterprise Membership | |
Training Course | Choose the course(s) to enrol in, from our library of ten courses | Upskill your knowledge with access to ALL of our available courses | Using our training framework, training content and expertise, build your own bespoke course that matches your environment. |
Training Course Access | Receive 12 months of training course updates and post-training insights, continuing your knowledge on the subject | Receive 12 months of training course updates and post-training insights, continuing your knowledge on the subject | Ensure your staff’s upskilling can be achieved seamlessly |
Training Server Access | 10 hours per course * Excluding Introduction to IBM Planning Analytics | 10 hours per course * Excluding Introduction to IBM Planning Analytics | Your content will be stored on our secure training platform, trusted by leading software companies worldwide. |
Training Options | Choose one of these options: – Self-Paced – Online Classroom (schedule) | Choose one of these options: – Self-Paced – Online Classroom (schedule)* * Excluding Slice, Apliqo UX and Apliqo UPM | Lock in regular training sessions with our consultants throughout the year. |
Digital badge | Achieve a digital badge that endorses the knowledge learnt for the course undertaken | Achieve a digital badge that endorses the knowledge learnt for the course undertaken | Achieve a digital badge that endorses the knowledge learnt for the course undertaken |
Community Hub | Stay up to date with the latest news dedicated to IBM Planning Analytics | Stay up to date with the latest news dedicated to IBM Planning Analytics | Stay up to date with the latest news dedicated to IBM Planning Analytics |
Video Hub | Not included | Access to hundreds of presentations with tips from consultants, models built by customers and insights from IBM | Choose to include |
Horizon, Global User Conference | Not included | Full access to all presentations for this coming event | Choose to include |