Posts by Patrick Quirke
How do I Create Calendar Offset Metrics in Pigment
Creating Calendar Offset Metrics in Pigment When writing formulas in Pigment, there may be a need to reference a calendar item that is offset from the one being calculated. Calendar Offset metrics can be created to solve this use case. They are two dimension metrics including the calendar dimension you need an offset for, and…
Read MoreHow can I Use Workflows to Automatically Send Targeted Emails
How to Use Workflows to Automatically Send Targeted Emails NetSuite offers multiple ways to streamline workflows, resolve operational pain points, and enhance system efficiency. One common challenge is notifying employees about transactions related to them. While NetSuite dashboards and portlets can display this information, workflow automation provides a more efficient solution by automatically sending targeted…
Read MoreHow do I gain immediate Insight into Key Metrics?
How do I gain immediate Insight into Key Metrics? NetSuite contains many different forms and tools, each designed to serve a specific purpose. However, some capabilities are not available out of the box. One common example is tracking how many times the data within a form has been revised or updated. This type of functionality…
Read MoreHow do I set up NetSuite Journal Entry Approvals?
How do I set up NetSuite Journal Entry Approvals: Setup Instructions Explained Journal entries are fundamental to every accounting department. They ensure financial results are recorded accurately, completely, and on time. In NetSuite, journal entries are used to record financial adjustments across one or more accounts, capturing the fiscal impact of business transactions and enabling…
Read MoreHow Can Pigment Be Used to Track Project Run Rates and Improve Revenue Forecasting?
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 MoreHow Does Pigment Support Workforce Planning Through Structured Metrics and Naming Standards?
How Does Pigment Support Workforce Planning Through Structured Metrics and Naming Standards? 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…
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 MoreWhat Is TM1 Drill-Through and How Do I Set It Up?
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 MoreHow Do I Remove 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 MoreHow Do I Perform Step-By-Step Consolidations in IBM Planning Analytics?
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 More