Advanced MDX (PAW)

Version: IBM Planning Analytics (PA) 2.0.9.19 and Planning Analytics Workspace 2.0.92

In this class, students learn:

• How to use CURRENTUSER to determine the current user that you are logged in as
• How to use StrToMember to determine what a user selected in a User Preference cube
• How to Filter members according to the current user’s inputs
• How to link MDX views to the user’s inputs, making it more dynamic
• How to create sets like current year and previous year according to cube values using the Generate function
• How to prevent errors by using the StrToSet and IIF functions
• How to enable MDX logging in your PA instance

At the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessment.