In this article we look into the sources and functions necessary to build a dimension’s hierarchy using an IBM Planning Analytics Turbo Integrator [TI] process. Read on to learn how to set it up, some best practices, and some troubleshooting tips. What TI functions are used to create hierarchy in a dimension? DIMENSIONELEMENTINSERT() and DIMENSIONELEMENTCOMPONENTADD()…

There are several factors to keep in mind when creating business rules in Planning Analytics. What are rules, you ask? Rules are dynamic calculations that enable analysts, department leads, and planners to transform their data into real-time insights. Rules are the secret sauce when reporting in PA, but with great power, comes great responsibility. Adding…

IBM Planning Analytics is great at performing many rule calculations across cells in a cube. Rules are useful for instant, calculated results in a cube based on user inputs. But as the number of rules against a Planning Analytics cube increases, the harder it can get to keep track of them all. Lots of rules…

Creating Picklists in Planning Analytics Picklists in Planning Analytics are the best way to help control the inputs users can put into a cell. When users are doing inputs into a cell, the possibility for error can be high. Imagine a rule that takes a value from an input cube and puts it into a…

The IBM Planning Analytics (TM1) ODBCOutput function is used in TurboIntegrator (TI) script to execute a SQL Update or Insert query against an open ODBC data source. ODBCOutput is very useful but can be slow if exporting large numbers of records, especially in a cloud environment. A typical TI process that uses ODBCOutput will have…

When writing Data Load – Turbo Integrator Processes in Planning Analytics, it is essential that effective Source and Zero-Out Views are created to ensure a correct transfer of Data. In Planning Analytics, a View is a user-defined collection of data intersections of a specified cube. The data intersections of a view are made up of…

Have you ever logged into your IBM Planning Analytics environment, seen a number and thought to yourself; I wonder when that was updated? Do you struggle to dig into the log files anytime something odd seems to have happened? Assuming the data changes occurred due to an automated process rather than manual changes, then building…

When using an ODBC data source for a Planning Analytics Turbo Integrator (TI) process, native TI parameters can be utilized within the SQL query.  Planning Analytics users have the power to be more specific and efficient with a query, potentially increasing performance by having less unnecessary data that needs to be read throughout the process,…

During the recent IBM Think 2019 conference in San Francisco, CA, I went to the “Planning Analytics Workspace for Power Users” session led by the PAW developers. They shared a lot of exciting new features that we can expect in upcoming PAW releases, along with some advanced tips and tricks that are already available today.…

In another #AskQueBIT (Drag and Drop Cube Load in Planning Analytics Workspace (PAW)) article, we showed you how to load data to a cube by dragging and dropping a .csv file onto the workspace. The cube that we used is relatively simple, with only 3 dimensions: Award Year Person Award However, both the Person and…