Cubewise


Cubewise has been on this mission since 2004. We’re a technology partner that you can count on for custom implementations and support to help you get the most out of IBM Planning Analytics / TM1.

Programs offered by Cubewise

End User (Planning Analytics for Excel)

Version: IBM Planning Analytics 2.0In this class, students learn:How to use the interfaceHow to analyse Cube dataHow to use the DimensionHow to use the SubsetHow to use each report typesHow to export data to ExcelHow to use an Action ButtonHow to publish a reportAn introduction to TM1 WebAn introduction to Data SpreadingAt the end of class, candidates go through a practical assessment to prove th…

Exploration and Quick Report

Version: Planning Analytics 2.0.9.20 and IBM Planning Analytics for Excel 2.1.11In this class, students learn:How to create and use these interfacesHow to format these interfacesHow to use alternate hierarchiesHow to set up multiple data sources on Quick ReportAt the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessme…

Administrator (Arc)

This student has proven their knowledge in the Administrator course on IBM Planning Analytics in ArcVersion: IBM Planning Analytics (PA) 2.0.9.20 and Arc 4.5.1In this class, students learn:How to manage a databaseHow to implement security and understand the different levelsHow to monitor a databaseHow to back up and restore a databaseAt the end of class, candidates go through a practical assessme…

Administrator (PAW)

Version: IBM Planning Analytics (PA) 2.0.9.19 and Planning Analytics Workspace 2.0.92In this class, students learn:How to manage IBM Planning Analytics database/sHow to implement security in IBM Planning Analytics and IBM Planning Analytics WorkspaceHow to monitor IBM Planning Analytics database/sHow to create snapshots of IBM Planning Analytics Workspace booksAt the end of class, candidates go t…

Advanced MDX (PAW)

Version: IBM Planning Analytics (PA) 2.0.9.19 and Planning Analytics Workspace 2.0.92In this class, students learn:How to use CURRENTUSER to determine the current user that you are logged in asHow to use StrToMember to determine what a user selected in a User Preference cubeHow to Filter members according to the current user’s inputsHow to link MDX views to the user’s inputs, making it more dynam…

Advanced Rules (Arc)

Version: IBM Planning Analytics (PA) 2.0.9.20 and Arc 4.5.1In this class, students learn:The fundamentals for writing RulesHow to use logic operatorsHow to feed to and from consolidationsHow to write a formula requiring data from other CubesHow to write a currency translation ruleHow to write a moving balance ruleHow to polish the TI process for productionHow to handle data sparsityAt the end of …

Advanced Rules (PAW)

Version: IBM Planning Analytics (PA) 2.0.9.19 and Planning Analytics Workspace 2.0.92In this class, students learn:The fundamentals for writing RulesHow to use logic operatorsHow to feed to and from consolidationsHow to write a formula requiring data from other CubesHow to write a currency translation ruleHow to write a moving balance ruleHow to polish the TI process for productionHow to handle d…

Advanced Rules (Perspectives)

Version: IBM TM1 10.2.2 and Planning Analytics 2.0In this class, students learn:Rules fundamentalsHow to write FeedersHow to use mathematical operators and functionsHow to write multi-cube rulesAt the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessment.

Advanced TurboIntegrator (Arc)

*Version: IBM Planning Analytics (PA) 2.0.9.20 and Arc 4.5.1In this class, students learn:TurboIntegrator programming principlesUnderstanding the different types of data sources that TI can useHow to define the data structureHow to build Views and SubsetsHow to use build and manage DimensionsHow to upload data to CubesHow to polish the TI process for productionHow to utilise Bedrock processes to …

Advanced TurboIntegrator (PAW)

Version: IBM Planning Analytics (PA) 2.0.9.19 and Planning Analytics Workspace 2.0.92In this class, students learn:TurboIntegrator programming principlesUnderstanding the different types of data sources that TI can useHow to define the data structureHow to build Views and SubsetsHow to use build and manage DimensionsHow to upload data to CubesHow to polish the TI process for productionHow to util…

Advanced TurboIntegrator (Perspectives)

Version: IBM Planning Analytics (PA) 2.0.9.19 and Planning Analytics Workspace 2.0.92In this class, students learn:TurboIntegrator programming principlesHow to use external data sourcesHow to parameterise TurboIntegratorHow to load data and maintain structureHow to debug codeHow to utilise Bedrock for TM1At the end of class, candidates go through a practical assessment to prove their knowledge. T…

AI Integration with watsonx.ai

The student has demonstrated practical experience in connecting to TM1 servers, extracting and preparing cube data, and leveraging foundation models for advanced analysis. Through hands-on exercises with Python, TM1py, and Jupyter Notebooks, they are equipped to apply AI-driven insights and automation within IBM Planning Analytics.At the end of the class, candidates complete a practical assessmen…

Custom Report / Slice

Version: Planning Analytics 2.0.9.20 and IBM Planning Analytics for Excel 2.1.11In this class, students learn:How to build a report from scratch in ExcelHow to manipulate the key featuresHow to apply filteringHow to include Excel graphsHow to use the advanced features in an Action ButtonHow to set up columns that can dynamically expand and collapse on consolidationsTM1 Functions for Excel you nee…

Developer Fundamentals (Arc)

*Version: IBM Planning Analytics (PA) 2.0.9.20 and Arc 4.5.1In this class, students learn:How to identify TM1 objects in ArcHow to develop and structure DimensionsHow to maintain Dimensions when the model goes liveHow to build a cubeAn introduction to writing business logic via RulesAn introduction to loading data via TurboIntegratorAt the end of class, candidates go through a practical assessmen…

Developer Fundamentals (PAW)

Version: IBM Planning Analytics (PA) 2.0.9.19 and Planning Analytics Workspace 2.0.92In this class, students learn how to:Best practice foundations for building cubesHow to develop and structure DimensionsHow to maintain Dimensions when the model goes liveAn introduction to writing business logic via RulesAn introduction to loading data via TurboIntegratorHow to set up user and group security on …

Developer Fundamentals (Perspectives)

Version: IBM TM1 10.2.2 and Planning Analytics 2.0In this class, students learn how to:Develop and Maintain DimensionsDevelop CubesWrite Rules at an introductory levelUse TurboIntegrator at an introductory levelSet up SecurityAt the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessment.

Dynamic Report / Active Forms

Version: Planning Analytics 2.0.9.20 and IBM Planning Analytics for Excel 2.1.11In this class, students learn:How to build a report from scratch in ExcelHow to manipulate the key featuresHow to apply filteringHow to include Excel graphsHow to use the advanced features in an Action ButtonHow to set up columns that can dynamically expand and collapse on consolidationsTM1 Functions for Excel you nee…

End User (Perspectives)

Version: IBM TM1 10.2.2 and Planning Analytics 2.0In this class, students learn:How to use the Cube ViewerHow to set up the Dimension Subset EditorHow to export data to ExcelHow to build reports in ExcelData Spreading capabilitiesHow to utilise sandboxesHow to interact with TM1WebAt the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 10…

End User (Planning Analytics Workspace)

Version: IBM Planning Analytics 2.0.92In this class, students learn:An overview of the PAW’s interfaceHow to analyse Cube data using by manipulating Dimensions and SubsetsHow to use utilise Hierarchies to get a different perspective on the dataHow to interrogate and understand the data using TraceHow to use data spreading for planning and forecastingHow to use create a new scenario for planning u…

End User (Slice)

Version: Slice 4.5.1.0 and Microsoft Excel 2019.Slice is an Excel add-in that allows you to display and update values from a TM1 database using cell-based functions. This course gives students the fundamentals to begin utilising Slice.In this class, students learn:How to use the ExplorerHow to use the Cube ViewerHow to use the Subset EditorHow to export to ExcelHow to use Cell AuditHow to use Pas…

Guided Planning (Planning Analytics Workspace)

Version: Planning Analytics 2.0.9.20 and IBM Planning Analytics for Microsoft Excel 2.1.11.The student has mastered:Creating structured books with optimised page layouts and navigationCustomising text boxes, displaying cell values, and managing tab iconsUsing action buttons to enhance interactivity and workflow efficiencyApplying conditional formatting to highlight due dates and key instructionsS…

MDX Fundamentals

Version: IBM Planning Analytics/TM1 server 2.0.9.20 and Planning Analytics Workspace 2.1.11.This course provides training on using Multidimensional Expressions (MDX) to retrieve a list of members in a dimension or analyze cube data within IBM Planning Analytics. This understanding of MDX empowers end users by offering additional controls, enhancing their ability to build reports in Excel and crea…

Pulse Fundamentals

Version: Pulse for TM1 version 6In this class, students learn:How to manage TM1 and Planning Analytics migrationHow to document the TM1 ServerHow to administer TM1 ServerHow to set up and monitor user securityAt the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessment.

TM1py Fundamentals

In this class, students learn:How to install and setup Python and TM1pyHow to find, access, and use TM1py functions to solve problemsHow to read and write (cell level) data and metadata with TM1pyHow to bring your TM1py scripts to a production-grade level.At the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessment.

Understanding the Value of IBM Planning Analytics / TM1

In this class, students learn:The limitations of ExcelWhat is IBM Planning Analytics / TM1What you can achieve with IBM Planning Analytics / TM1The concept of a model in IBM Planning Analytics / TM1The various interfaces for IBM Planning Analytics / TM1At the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessment.

Universal Report

Version: Planning Analytics 2.0.9.20 and IBM Planning Analytics for Excel 2.1.11In this class, students learn:How to export and use the Universal ReportHow the Universal Report worksHow to adjust the report to your requirementsHow to format the Universal ReportAt the end of class, candidates go through a practical assessment to prove their knowledge. This candidate received 100% on their assessme…