Cubewise EDU
ConsultingEducationSoftwareKnowledge HubSupportCompany
GB
    global-search

    Who is it for

    Developers

    Duration

    8 hours

    Difficulty

    Advanced

    Prerequisites

    End User PathwayDeveloper FundamentalsAdvanced RulesAdvanced TurboIntegrator

    Product

    IBM Planning Analytics Workspace

    Next Course

    TM1py Fundamentals [optional]Pulse Fundamentals [optional]Apliqo UX – Apliqo Certified Professional [optional]Apliqo UPM – Apliqo Certified Professional [optional]

    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 CoursePower User MembershipEnterprise Membership
    Training CourseChoose the course(s) to enrol in, from our library of ten coursesUpskill your knowledge with access to ALL of our available coursesUsing our training framework, training content and expertise, build your own bespoke course that matches your environment.
    Training Course AccessReceive 12 months of training course updates and post-training insights, continuing your knowledge on the subjectReceive 12 months of training course updates and post-training insights, continuing your knowledge on the subjectEnsure your staff’s upskilling can be achieved seamlessly
    Training Server Access10 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 OptionsChoose 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 badgeAchieve a digital badge that endorses the knowledge learnt for the course undertakenAchieve a digital badge that endorses the knowledge learnt for the course undertakenAchieve a digital badge that endorses the knowledge learnt for the course undertaken
    Community HubStay up to date with the latest news dedicated to IBM Planning AnalyticsStay up to date with the latest news dedicated to IBM Planning AnalyticsStay up to date with the latest news dedicated to IBM Planning Analytics
    Video HubNot includedAccess to hundreds of presentations with tips from consultants, models built by customers and insights from IBMChoose to include
    Horizon, Global User ConferenceNot includedFull access to all presentations for this coming eventChoose to include
    Enroll today