Recently Added
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 MoreReferencing 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 MoreEnabling 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 MoreControlling 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 MoreBuilding 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 MoreFeatured Resources
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. The following outlines the process of creating and deploying a working SSIS package that takes…
Read MoreOfficeConnect has many helpful features that enable detailed report creation tailored to customer needs. Below are a handful of advanced features worth pointing out. Absolute vs Relative Time Most often you will want to open a report and view it as of a certain date without manually updating the report. By properly building your report…
Read MoreIf you are more of a code-junkie at heart like me, or perhaps have come from a relational database background, you may want to think about the following concept. By now, you most likely understand how to build cubes using Planning Analytics Workspace (PAW). If not, you can have a look here. Similar to TM1…
Read MoreReducing Calculations with Text in Anaplan Reducing Calculations in Anaplan improves performance, and I am not referring to reducing line items. I am talking about the pieces of each formula in the line items. Anaplan’s engine is designed primarily to complete tasks that are Boolean, followed by numerical, like most computers. When you leverage text,…
Read More