Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    Who is it for

    End Users and Developers

    Duration

    4 hours

    Difficulty

    Intermediate

    Prerequisite

    Exploration and Quick Report orEnd User (Perspectives) orEnd User (Slice)

    Product

    IBM Planning Analytics for ExcelTM1 PerspectivesSlice

    Next Course

    Dynamic Report / Active Forms

    Custom Report / Slice

    This course is a deep dive into the most customisable reporting type, Custom Report (IBM Planning Analytics for Excel) / Slice (Perspectives and Slice). You will learn to set up your own reports with graphs and how to implement an Action Button.

    Our course material has been specifically designed so that users of IBM Planning Analytics for Excel, Perspectives, and Slice can produce a Custom Report / Slice.

    In this course, you will learn the following lessons:

    • How to build a report from scratch in Excel
    • How to manipulate the key features
    • How to apply filtering
    • How to include Excel graphs
    • 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 an Excel report

    Interested in enrolling?

    View all enrolment options.
    Enroll today