Did you know you can use Planning Analytics’ drill-through feature to access detailed data in another Planning Analytics cube or a configured relational table? This feature can allow for a user to quickly find detailed information underlying a data point which is either in the model in a more detailed cube, or not in Planning…

You’ve created some basic rules and feeders against one of your Planning Analytics cubes and have used the SKIPCHECK and FEEDERS declarations (best practice).  But what does FEEDSTRINGS do and do you need it? The FEEDSTRINGS declaration makes sure any STRING cells in a cube that need to be calculated by a rule are fed.…

IBM Planning Analytics Workspace (PAW) is a web-based interface for IBM Planning Analytics. It delivers an intuitive interface to the data residing in Planning Analytics (TM1), providing ways to plan, create, and analyze your content by providing features such as conditional formatting and calculations. One interesting feature available in PAW, is the ability to perform searches entered in…

The ASCIIOutput function creates a comma-delimited record in an ASCII output file. This function is a TurboIntegrator function and it can be used to export data, debug a TurboIntegrator process, or generate an ASCII file for many purposes. This article will show the syntax of this function and some examples of its arguments. In addition,…

The short answer is Yes! These are invaluable elemental information functions within Planning Analytics. These functions can be used in Rules, Worksheets, and TI Processes. ELPAR and ELCOMP are very similar to one another and have other related functions which can return information about how elements reside within dimensions. In this post, I will discuss…

ELISANC is one of the more versatile functions in Planning Analytics. The function determines whether the first element is an ancestor of the second element. This function returns 1 if the relationship is true, and it returns 0 if the relationship is not true. Although ELISANC can be used in rules and TurboIntegrator (TI), we…

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()…

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,…

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 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…