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 learning this course? Choose the enrolment option that suits you

	Single Course	Power User Membership	Enterprise Membership
Training Course	Choose the course(s) you want to learn	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	4 hour course = 5 hours of server access 8 hour course = 10 hours of server access	4 hour course = 5 hours of server access 8 hour course = 10 hours of server access	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) ## – In-person Classroom ###	Choose one of these options: – Self-Paced # – Online Classroom (schedule) ## – In-person Classroom ###	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

Enrol today

* A server is not required for the ‘Understanding the Value of IBM Planning Analytics’ course. A server for Apliqo UX and Apliqo FPM are organised by Apliqo.

# Start any time and date with server access for 7 consecutive days, including 1 hour of mentoring (excludes Apliqo UX and Apliqo FPM). For Apliqo UX and Apliqo FPM, the Apliqo team will help set up the environment and training.

## There are no scheduled online classes for Apliqo UX and Apliqo FPM courses. Exclusive classes can be organised, for an additional cost.

### Exclusive classes for the customer where the local office organises the classroom, catering and trainer.