Dynamic Reports with MDX Dynamic Reports in Planning Analytics for Excel (PAfE) takes “complex reporting” to a whole new level! This report is fully embedded within Excel and utilizes TM1 formulas. One of the greatest strengths of this report type is that it allows for expandable / collapsible rows, dictated by the TM1RPTROW formula. There…

Title: Loading Data to IBM Planning Analytics using TM1Py and Pandas Part 1 Author(s): Paul Caggiano Application: Planning Analytics, Python Software Version: Planning Analytics Version 11.8.01300.1; Python 3.9.12 Keywords: TM1Py, Python, Planning Analytics, TM1, Pandas   Python is no doubt one of the fastest growing programming languages in terms of its use for data science.  This…

Title: Loading Data to IBM Planning Analytics using TM1Py and Pandas Part 2 Author(s): Paul Caggiano Application: Planning Analytics, Python Software Version: Planning Analytics Version 11.8.01300.1; Python 3.9.12 Keywords: TM1Py, Python, Planning Analytics, TM1, Pandas   This article is Part 2 of the series exploring how to integrate TM1Py with your IBM Planning Analytics (PA) instance…

Title: Loading Data to IBM Planning Analytics using TM1Py and Pandas Part 3 Author(s): Paul Caggiano Application: Planning Analytics, Python Software Version: Planning Analytics Version 11.8.01300.1; Python 3.9.12 Keywords: TM1Py, Python, Planning Analytics, TM1, Pandas   This article is Part 3 of the series exploring how to integrate TM1Py with your IBM Planning Analytics (PA) instance…

The power of IBM Planning Analytics (PA or TM1) comes from its ability to receive input information from different users, take that input and, through rules embedded in the model, consolidate a forecast (budget), or demonstrate variances to actuals. As developers working with PA we have to build models that perform well in the back…

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…