In other articles I’ve discussed the process of integrating data from various sources into IBM Planning Analytics. This time, I want to offer a simple strategy for automating the inflow of data “dropped onto” a File Transfer Protocol (or FTP) site. Since the File Transfer Protocol is a standard communication protocol commonly used for the…

Synchronization in computing can be defined as “…the action of causing a set of data (or files) to remain identical in more than one location…”. In IBM Planning Analytics Workspace (or PAW) we can equate this to objects (perhaps an Exploration View and a Visualization) that you’ve configured to be synchronized within a PAW Sheet.…

IBM Planning Analytics is a view-based application which supports data analysis, planning and creation of content. Using Planning Analytics Workspace (PAW) you can easily save and then share content that you have developed. Your content can be any number of objects such as a PAW “book”. PAW Books provide a canvas or “container” in which to layout…

You can explore IBM Planning Analytics data using Exploration Views. Using Exploration Views, you can not only quickly change how you see data – you can also manipulate the data to better understand relationships within the data. Here are just a few techniques you can use to manipulate an Exploration view in Planning Analytics Workspace (PAW): To…

You can add rules (or “formulas”) to a cube in IBM Planning Analytics to create complex data calculations based upon your organizations business rules. Rules can do a variety of things, such as override consolidations that are occurring in the cube, calculate values (like sales = units multiplied by item price), and so on. But Planning…

As IBM Planning Analytics (PA/TM1) developers we often find ourselves in need to manipulate attributes in a dimension. This manipulation may be with the purpose of creating said attribute or populating it with data. We assume here the manipulation will be done via the Turbo Integrator (TI) tool. So, any manual interaction with attributes is…

This article is the second part of a 3-part series exploring attribute manipulations with Turbo Integrator (TI) processes. In Part 1 of the series, which can be found here, we saw how to check if an attribute exists and insert it and then how to check its type. We will now continue with a more…

This article is Part 3 of a series called Advanced Attribute Manipulation. You can find Part 1 which describes a few functions used to check if attributes exists and how to check their type HERE. And Part 2 about useful functions that looping through an attribute dimension and perform tasks with a subset HERE. Our…

Ranking reports are simple, yet powerful end-user reporting tools. Providing the ability for a user to add a ranking to a report or view of data based upon criteria that they are specifically interested in without having to have a developer or application administrator involved can be invaluable. IBM Planning Analytics Workspace users can enhance their…