Sep 4 2023

    Cubewise EDU’s September Newsletter

    Check out what’s happening in the world of IBM Planning Analytics, and harness our focus and enthusiasm to your benefit in one or more ways!

    Upskill your know-how on IBM Planning Analytics/TM1, through our consultant-led training.

    Classes will commence on September 4th and be conducted over two half-days, allowing students to balance work and online studies.

    Class Timing:
    Australian Time Zone: 9:00 am to 1:00 pm AEST
    European Time Zone: 8:00 am to 12:00 pm BST

    Developer Fundamentals
    Learn the fundamentals of dimension building, cube design, data loading, writing Rules and TurboIntegrator processes.

    Advanced TurboIntegrator
    Learn how experts use TurboIntegrator (TI) to write code beyond the restrictions provided by the wizard.

    Advanced Rules
    Learn how to write multi-cube logic and clearly understand how feeders work to ensure an efficient model.

    Check our website for more details on each course.

    Interested in upskilling with multiple courses? Join the Power User Membership and enjoy the following benefits:
    – An online ticket to Horizon, the global user conference on IBM Planning Analytics / TM1
    – Exclusive access to the Power User Community, a dedicated space to share insights and interact with your peers who are also passionate about IBM Planning Analytics / TM1. 
    – Access to 300+ EDU Video Library from Horizon and webinars
    – Flexibility to attend online classrooms or self-paced learning for all our courses
    – Extra insights on the course topics.

    Email for more information.

    EDU Induction sessions, are designed to help you maximise the benefits of our educational content. These sessions will equip you with the knowledge and tools necessary to make the most out of your membership.

    Session Schedule:
    Induction sessions are conducted fortnightly to accommodate various schedules. We highly recommend that all students attend at least one induction session to get started on the right foot.

    What to Expect:
    – Discover the numerous benefits included in your membership.
    – Explore the Community Hub and learn how to connect with fellow learners.
    – Navigate through our Video Hub, where you can access a wealth of informative content.
    – Get step-by-step guidance on how to start your learning journey.
    – Stay updated on upcoming events to enhance your educational experience.
    – Participate in a Q&A session to clarify any doubts you may have.

    Please mark your calendars for the upcoming sessions and feel free to attend the one that suits you best.

    Looking forward to seeing you at the next Induction session!

    We are excited to release the Advanced Reporting (PA for Excel) Post Training Insight, Suppress zero using check box.

    Instead of using an Excel data validation, let’s look at how to use a check box instead.

    Gear up to explore new perspectives at Horizon, on Tuesday, 17 October 2023

    Here’s a glimpse of what’s in store for End Users:

    Planning Analytics for Excel (PAfE) Fundamentals: Reporting Kick-Start
    Jump start your reporting journey with Planning Analytics for Excel. Learn to create reports using PAfE’s four report types: Exploration Views, Quick Reports, Custom Reports, and Dynamic Reports.

    PA Workspace 101
    Discover IBM’s ongoing improvements in PAW and learn about new features to enhance your dashboard experience. This session explores a range of tools and techniques, both new and existing, to elevate the look and functionality of your dashboards.

    PAW Reporting with Dynamics Subsets (moving away from Excel)
    Explore WaterNSW’s transformative journey from Excel to web-based PAW workbooksSee how Dynamic Subsets adjust visualisation filters dynamically, creating reports tailored to users.

    Developer-focused presentations to look forward to:

    TM1 Memory Explained: Why does TM1 use so much memory
    Memory is a key resource for TM1. Understanding how it is used and what can impact it can help improve the running of a model and ensure a good user experience.

    PAW Synchronisation 101: The When, Where, and How of it All
    Discover how to create seamless workbook synchronisation in PAW and elevate the user experience for a smoother workflow.

    TM1py vs. TI Approach – Going further on Data Integration!
    Are you facing tasks that seem beyond the capabilities of traditional TI processes? Look no further! Unleash the potential of TM1py and Python to achieve seamless data integration and processing tasks.

    Get ready to supercharge your memory, learning, and mental performance with our keynote speaker Tansel Ali, the renowned Memory Master!

    Names and People Connection:
    Master the art of remembering names and faces to enhance your social and professional interactions.

    How to Learn Anything Fast:
    Uncover powerful strategies to learn faster and more by understanding the psychology of memory.

    Killing Procrastination:
    Overcome procrastination with cognitive insights and practical strategies. Optimise mental focus, goal-setting, and apply techniques to enhance memory retention and productivity.

    Memory Technique 1:
    Unleash the power of Memory Technique #1 to effortlessly recall lists, sequences, and speeches.

    Memory Technique 2:
    Harness spatial memory with Technique #2. Develop personalised memory techniques and effortlessly recall information stored in familiar mental spaces.

    Mental Training – Encoding Exercises:
    Improve your memory with advanced encoding training. Convert information into memorable formats through interactive exercises to increase your memory capacity and speed.

    Memory Principles for Better Memory:
    Master memory principles for better recall. Explore memory functions, types, and influencing factors through interactive tests.

    Storytelling for Abstract Data:
    Transform complex data into memorable stories. Learn narrative techniques to simplify information, enhancing memory and data communication.

    Managing Stress and Anxiety:
    Combat the effects of stress on memory and cognition. Understand the relationship between stress and memory and apply techniques for optimal mental performance.

    Stay tuned for more exciting previews! For inquiries, reach out to us at

    Learn a new way to build Excel reports with TM1!

    In this presentation, TM1 expert Luis Rincon introduces the game-changing MDX Form. 

    Watch Luis’s insightful presentation, Building the next generation of Active Forms with Slice from Horizon 2022 to learn how to:
    – Build the Next Generation of Active Forms with Slice
    – Utilize View Style Editor and Generate MDX Formulated Reports in Slice
    – Seamlessly Insert an MDX Form into an Excel Report
    – Create MDX Forms in Slice: Your Guide to Enhanced Report Building

    Meet João, Cubewise Consultant. Hailing from Brazil, he had a transformative moment when he immersed himself in the intricacies of TM1. What fascinated him the most was the ability to efficiently distribute data within TM1. To him, TM1 represented something more than just a tool— it was like a corporate version of Excel, but with enhanced governance measures.

    In this episode of “15 minutes with..” Jon Lee sits down with Chris Yate, at the London Planning Analytics User Conference 2023.

    – Gain insights into Chris’s TM1 journey from the beginning.
    – Discover his valuable TM1 experiences and expertise. 
    – Uncover Chris’s passion for why TM1 holds a special place.

    Whether you’re a TM1 enthusiast or simply curious about the journey, this episode has something exciting in store for everyone.

    Related content

    Loading related content