IBM
How Do I Use IF and WHILE Statements in IBM Planning Analytics TurboIntegrator Processes?
Using IF and WHILE Statements in IBM Planning Analytics TurboIntegrator Processes IBM Planning Analytics provides powerful scripting capabilities within TurboIntegrator (TI) processes, allowing developers to create dynamic, flexible models. Two foundational constructs used in these scripts are the IF and WHILE statements. IF statements are primarily used for conditional execution of code, and WHILE statements…
Read MoreHow Do I Reference Values Using Hierarchies in IBM Planning Analytics?
Referencing Values Using Hierarchies in IBM Planning Analytics IBM Planning Analytics enables developers to create sophisticated models by utilizing cell references in TurboIntegrator (TI) processes and rules. With the introduction of hierarchies in dimensions, developers can now leverage these references to perform targeted updates, calculations, and validations at various levels within a hierarchy. This article…
Read MoreHow Do I Enable Drive Explorer in Planning Analytics Workspace on Cloud?
Enabling Drive Explorer in Planning Analytics Workspace on Cloud IBM’s new Drive Explorer gives Admins back some of the functionality that was lost with the depreciation of the Rich Tier Desktop in 2024. It gives admins the ability to move files from one environment to another and also includes some compression/decompression features that simplify the…
Read MoreHow Do I Manage and Control Access to the Shared Folder in IBM Planning Analytics?
Controlling the Shared Folder In the past, it was possible to have control over who can access certain subfolders within the Planning Analytics shared folder and what their permissions would be. Going forward, with the implementation of Drive Explorer (in Planning Analytics Workspace modeling workbench) subfolder control doesn’t work the same way. That is, adding…
Read MoreHow Do I Build Supporting Coding Skills for IBM Planning Analytics Development?
Building Supporting Coding Skills for IBM Planning Analytics Development Becoming an expert at IBM Planning Analytics development requires proficiency in multiple syntaxes and languages. TurboIntegrator and Rule scripting has limited documentation and learning resources outside of the official IBM PA documentation. However, several other coding languages with extensive resources are invaluable for building foundational skills.…
Read MoreHow Do I Use PAW Drive Explorer to Edit Files in IBM Planning Analytics Workspace (PAW)?
Editing Files using PAW Drive Explorer You may already be aware that the Rich Tier Desktop is “going away” and Planning Analytics on Cloud Modelers will need to use Planning Analytics Workspace (or “PAW”) for administrative tasks, including using Drive Explorer for individual file management, such as copying or moving files or folders across cloud environment…
Read MoreHow Do I Sync Planning Analytics Environments Without the Rich Tier?
Deprecation of the Rich Tier Desktop The IBM Planning Analytics on Cloud team has announced that, the Rich Tier Desktop is soon to be no longer accessible for Planning Analytics on Cloud Modelers and you will now use Planning Analytics Workspace (or “PAW”) for all of your administrative tasks, including restoring or “synchronizing” files or folders in…
Read MoreHow Do I Use Event Thresholds and Alerts in IBM Planning Analytics Workspace?
Observability and Monitorability Key components of modern-day enterprise software are observability (visibility into the activities occurring within the software) and monitorability (defining threshold limits for critical system metrics). IBM Planning Analytics provides both when using Planning Analytics Workspace (or PAW). Monitoring Activity You can view a detailed report of all current activities (known as “threads”)…
Read MoreHow Do I Enable Performance Monitoring in IBM Planning Analytics Workspace?
Enabling Performance Monitoring in IBM Planning Analytics Workspace PA/TM1 Performance Monitor is a collection of tools that monitor the performance of IBM PA/TM1 servers in real-time. It can track and store performance data in control cubes, such as StatsByClient, StatsByCube, StatsByCubeByClient, and StatsForServer. These cubes track various statistics, such as message count, average message size, memory use, and…
Read MoreHow Do I Use the Planning Analytics for Excel API to Automate Tasks with Macros?
Planning Analytics for Microsoft Excel API for Macro Automation It’s not uncommon to move an MS Excel workbook from Perspectives to Planning Analytics for Excel (PAfE) and find that there are buttons within the workbook that run macro(s) to perform automation tasks. If there are, you may encounter the following (or similar) error: “Cannot run…
Read More