Posts by Patrick Quirke
Project Tracking with Pigment
Project Tracking with Pigment Streamlining Project Forecasting with Run Rate Management in Pigment Effective project forecasting is crucial for revenue planning and operational efficiency. To improve the accuracy and timeliness of forecasting, a shift has been made from legacy planning tools to Pigment, a modern planning platform. This migration is specifically designed to enhance the…
Read MorePanda Doc in Pigment
Panda Doc in Pigment Inside a Pigment Implementation: Metrics, Naming Standards, and Workforce Planning A recent walkthrough of a completed Pigment implementation provides key insights into how this modern planning tool compares to legacy systems like Planning Analytics, and how it supports scalable, structured financial planning—particularly for workforce management. Workforce Planning and Metric Structure In…
Read MoreAutomating TM1 with R Scripting
Automating TM1 with R Scripting Exploring Automation and Load Balancing Testing with Python and TM1 When working with complex analytics systems like TM1, one of the key challenges is efficiently automating tests and managing performance in large-scale environments. This article explores how Python and TM1 Pi, a Python library for TM1, can be leveraged to…
Read MoreTM1 Drill through 101
TM1 Drill through 101 Optimizing TM1 Drill Through Functionality for Effective Data Exploration Drill through functionality in IBM Planning Analytics (TM1) is a powerful tool that enables users to access detailed, underlying data directly from summary views. When implemented thoughtfully, drill throughs can significantly enhance user understanding, reduce confusion, and support more effective planning…
Read MoreRemoving Element Level Security in IBM Planning Analytics
Planning Analytics Security You can create and implement a security scheme in TM1\Planning Analytics to secure objects and data in your server by defining security groups and clients (users), assigning access permissions to those groups and then assigning users to one or more of the groups. A good security schema will typically consider controlling access…
Read MorePlanning Analytics – Step by Step Consolidations
Planning Analytics – Step by Step Consolidations What is Consolidation? In Planning Analytics/TM1, dimensional elements that represent aggregations are called “consolidated elements” or consolidations (business users may also refer to them as “groupings”). The following image shows three levels of consolidation for elements of a Period dimension. The months (200801) provide the lowest level of detail (or…
Read MoreSynchronize Planning Analytics Database Groups with Planning Analytics Workspace Groups
Synchronize Planning Analytics Database Groups with Planning Analytics Workspace Groups With the release of Planning Analytics Workspace version 2.0.89 the ability to synchronize user groups between Planning Analytics Workspace and Planning Analytics databases was added. This allows users with the ability to assign security access a method to quickly add users to PA groups based…
Read MoreAccessing Process Error Logs in Planning Analytics Workspace
Accessing Process Error Logs in Planning Analytics Workspace With the release of Planning Analytics Workspace version 2.0.88 an additional way to view process error logs has been added into the Planning Analytics Workbench. The addition of this method of viewing process error log files is a great quality of life improvement to troubleshooting process issues,…
Read MoreCell Level Security in IBM Planning Analytics
Cell Level Security Planning Analytics cell level security provides the ability to secure individual cells without the need for a complicated series of element-level security cubes, which sets control on cells in a cube identified by dimension elements. Cell-level security can add a more finite level of control to a cube but can also become…
Read MoreCanceling Threads and Disconnecting Users in Planning Analytics
Canceling Threads and Disconnecting Users in Planning Analytics If you are new to IBM Planning Analytics or particularly to administrating with Planning Analytics Workspace, then the following information may be of interest. Keep in mind that we’re focusing here on just a few administrative tasks and functions, while there are plenty of others you’ll want…
Read More