IBM Planning Analytics
How to: Check whether a Dimension exists in IBM Planning Analytics
Last Updated: January 20, 2026One of the key features of Turbo Integrator in IBM Planning Analytics is the ability to check whether a dimension exists before importing data. Turbo Integrator remains a...
How to: Control Who Has Access to the Planning Analytics Assistant
Last Updated: January 15, 2026The Planning Analytics Assistant introduces generative AI capabilities into IBM Planning Analytics, allowing users to explore and understand data using natural language and AI-generated explanations. As organisations adopt AI-enabled features,...
5 Top Tips for Working with Planning Analytics for Excel (PAfE)
Last Updated: December 3, 20255 Top Tips for Working with Planning Analytics for Excel (PAfE) By Adam Bakhtiar If you use IBM Planning Analytics for Excel (PAfE) regularly, you’ll know just how powerful it...
How to: Add Spacer Rows and Columns to Universal Reports in Planning Analytics for Excel (PAfE)
Last Updated: September 15, 2025If you are using PAfE 2.1.12 or later, you may notice that the context menu in Excel does not provide the option to add spacer rows or columns directly. To...
How To: Subscribe to IBM Security Bulletins for Planning Analytics, Cognos Analytics and Controller
Last Updated: September 9, 2025What is a Security Bulletin? From time to time, IBM identifies vulnerabilities in its software. When that happens, they issue a Security Bulletin. These bulletins explain: A summary of the...
How to: Load a file via process in Planning Analytics Workspace (PAW)
Last Updated: August 8, 2025Load a File via Process in Planning Analytics Workspace (PAW) Sometimes you’ve got a file on your network or PC – maybe a spreadsheet you’ve created or adjusted – and...
How To: Find out your Planning Analytics Version using Workbench (Planning Analytics on Cloud)
Last Updated: June 25, 2025If you’re struggling to find out what your Planning Analytics version is, you can follow the steps below. Please note that Live and Dev environment might have different Planning Analytics...
How To: Create a simple hierarchy in Planning Analytics
Last Updated: January 17, 2025This article gives you a step by step guide on how to create a new hierarchy within a dimension in Planning Analytics using standard product functionality. In a PAW (Planning...
How to: Change maximum login attempts to Planning Analytics on Cloud
Last Updated: November 13, 2024IBM Planning Analytics is a a secure platform that requires users to log in with their credentials. However, sometimes users may forget their passwords or enter incorrect login details, which...
How to: Using the While statement Turbo Integrator Process in IBM Planning Analytics
Last Updated: November 13, 2024The ‘while’ function in Turbo Integrator is used to repeat a set of instructions until a certain condition is met. This can be useful when you need to perform a...
How to: Change a Dimension Element Weight in Planning Analytics via TI process
Last Updated: October 7, 2024In Planning Analytics, you can change the weights of an element in a dimension several ways. You can do it manually, however, we have found that re-running an associated TI...
Aramar Tips: Moving Databases in Planning Analytics
Last Updated: October 7, 2024In IBM Planning Analytics Cloud or on-premise, you may need to move databases between environments. We have created a checklist you can use to move your database from production...
How to: Mapping a CSV data source directory in IBM Planning Analytics on Cloud
Last Updated: October 7, 2024The Cloud version works a little differently from the local version of IBM Planning Analytics. IBM Planning Analytics on Cloud will only pick up a csv file from the shared...
How to: Mapping a Network Drive between Live and Development Environments in Planning Analytics on Cloud
Last Updated: October 7, 2024If you have a live and a development environment, you can map or link a shared directory between both. This can be useful if you need to move files between...
How To: Resolve ODBC error ‘unable to open connection to database’ in IBM Planning Analytics
Last Updated: October 7, 2024When trying to connect to a new source via ODBC using TM1’s Turbo Integrator, a User may see the following message when trying to connect: To resolve, check all...
How To: Investigating issues using the TM1 Server Log
Last Updated: October 7, 2024TM1 provides a log of every action that occurs within TM1. To investigate any issues within TM1, the ‘TM1Server’ Log is a good place to start investigating. Locating the Log...
How To: Check the version of IBM Planning Analytics for Excel
Last Updated: October 7, 2024To check the version of IBM Planning Analytics for Excel, follow these steps: Open Microsoft Excel Click the IBM Planning Analytics tab. In the Getting Started group, click Help. Click About. The version will appear in...
How to: Check and manage your IBM Planning Analytics licence usage vs. your licence entitlement
Last Updated: October 7, 2024In IBM Planning Analytics, you have the ability to add additional Modelers, Users and Explorers as and when you need them. This means that you can consume additional licences for...
How to: Change the display row limit in Planning Analytics for Excel
Last Updated: October 7, 2024If you have cube view that has a lot of rows, by default Planning Analytics for Excel will limit how many rows can be displayed in Exploration, Quick Reports, or...
How To: Set up Inactivity Timeout Sessions in IBM Planning Analytics
Last Updated: September 30, 2024For security reasons Planning Analytics has a built in time out session. Your Planning Analytics session will time out if there’s no activity for a set period of time. When...
How To: Install Planning Analytics for Excel (PAfE)
Last Updated: March 8, 2024IBM Planning Analytics for Excel (PafE) is an Excel add-in that enables you to interact with data and perform powerful planning, budgeting, and forecasting activities using IBM Planning Analytics with...
How to: Check the Security of a Dimension in IBM Planning Analytics
Last Updated: December 7, 2023To help illustrate how you can check the security of a dimension, this article includes an example of a user is not able to write to a record on the...
Aramar Tips: Using PowerShell in Planning Analytics
Last Updated: May 9, 2023PowerShell is Microsoft’s modern powerful scripting and cross-platform solution that runs on Windows, Linux, and macOS An IBM Planning Analytics application can be configured to build and run its own...
Fundamentals: Feeders in IBM Planning Analytics
Last Updated: May 9, 2023In IBM Planning Analytics, Feeders solve a real modelling problem that we have in business reporting and planning systems. IBM Planning Analytics is very efficient at calculating totals. It does...
Fundamentals: Cube Viewer in Planning Analytics for Excel
Last Updated: May 9, 2023Working with the Planning Analytics Cube Viewer Planning Analytics for Excel is full of tools and functions that help you do your job. One of the most helpful is the...
Fundamentals: DBRW in Planning Analytics
Last Updated: May 9, 2023When you are starting out using Planning Analytics (TM1) the world of rules can be daunting There are hundreds of rules and finding the one you need with a good...
How to: Create a Dimension in IBM Planning Analytics
Last Updated: May 9, 2023Planning Analytics for Excel has many functions for data analysis within the cube viewer. In this article we’ll show you the top 5 functions that are useful for analysis. A quick...
Fundamentals: What are Dimensions in IBM Planning Analytics?
Last Updated: May 9, 2023A dimension is a way of describing data within cubes. They represent the ‘who’, ‘what’, ‘where’ and ‘when’ of the data. A dimension may also contain the ‘how many, ‘how...
How to: Edit Dimensions in IBM Planning Analytics
Last Updated: May 9, 2023You may find that once a dimension has been created, changes need to be made which could include changes to the hierarchy, items may need to be added or deleted,...
How to: Create a Cube in IBM Planning Analytics
Last Updated: May 9, 2023By bringing two or more dimensions together, you can create a data cube. Inside the cube the intersection of each single element in each dimension can hold a value. So,...
How to: Create Subsets driven by another Dimension in Planning Analytics
Last Updated: May 3, 2023IBM Planning Analytics allows us to create views that are built from sets or a selection of elements for each dimension in the cube This is a great way of...
Aramar Tips: Creating documentation IBM Planning Analytics
Last Updated: May 3, 2023Easy to read and understand IBM Planning Analytics rules and processes save time, money, and stress in the long run. They also give users the confidence to make changes and...
Aramar Tips: Checking your parameters with a Planning Analytics TI Process
Last Updated: May 3, 2023Planning Analytics TurboIntegrator processes allow us to set up parameter to control data processing Planning Analytics Workspace has a handy interface to help you build TurboIntegrator processes. However, you can...
Aramar Tips: Analysing Data in IBM Planning Analytics for Excel
Last Updated: May 3, 2023Planning Analytics for Excel has many functions for data analysis within the cube viewer. In this article we’ll show you the top 5 tips function useful for analysis. A quick...
How to: Add a new Element to an existing Dimension in IBM Planning Analytics
Last Updated: May 2, 2023To add an element into a dimension you need to go into the ‘Data and Models’ section of IBM Planning Analytics Workspace. Open the workbench and highlight the ‘Dimensions’ selection: ...
Aramar Tips: Working with Subsets in IBM Planning Analytics
Last Updated: May 2, 2023IBM Planning Analytics allows you to see the data you want to see in your own way. This helps in producing reports and regular analysis that you need to do...