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
