Advanced MDX
This course is a deep dive into MDX (MultiDimension eXpression), a language used to query the TM1 Server for extracting data and structure. Understanding how to read and write MDX will enable you to enhance Excel reports beyond the standard Dynamic Report export. It would also put you on the right step to learning TM1py since understanding MDX is fundamental. Here is a breakdown of the lessons covered in this course:
- 1. Learn how to use CURRENTUSER to determine the current user that you are logged in as
- 2. Learn how to use StrToMember to determine what a user selected in a User Preference cube
- 3. Learn how to Filter members according to the current user’s inputs
- 4. Learn how to link MDX views to the user’s inputs, making it more dynamic
- 5. Learn how to create sets like current year and previous year according to cube values using the Generate function
- 6. Learn how to prevent errors by using the StrToSet and IIF functions
- 7. Learn how to enable MDX logging in your PA instance
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 |
* 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.