Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    Who is it for

    This course is no longer available. It has been preceded by Custom Report / Slice and Dynamic Report / Active Forms.

    Duration

    8 hours

    Difficulty

    Intermediate

    Prerequisite

    End User (Excel)

    Product

    IBM Planning Analytics for Excel or Perspectives

    Next Course

    End User (PAW)

    Advanced Reporting (Excel)

    This course is deep dive into the most formative reporting type in IBM Planning Analytics, Dynamic Report (aka Slice for Perspectives). You will learn to take advantage of Dynamic Report’s consolidation expandability and automated format definitions, key features you need to know. In this course, you will learn the following lessons:

    • How to build a report from scratch in Excel
    • How to manipulate the Dynamic Report’s key features
    • How to apply filtering on a Dynamic Report
    • How to include Excel graphs in a Dynamic Report
    • How to use the advanced features in an Action Button
    • How to set up columns that can dynamically expand and collapse on consolidations
    • TM1 Functions for Excel you need to know
    • Best practice principles for building and Excel report

    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 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 OptionsChoose 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 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
    Enrol today