While developing an IBM Planning Analytics (PA) model, you may have come across a situation similar to the following:  A rule and feeder are seemingly working correctly, but upon a data change the expected cells are not returning values, implying they are no longer being fed.  Consider the example below showing a simple rule from…

IBM Planning Analytics (PA) allows administrator (admin) users to control users’ read and write access through different levels of object security. The system provides a set of redefined groups for admin purposes but allows custom groups to be created as well that users can belong to. Planning Analytics admins commonly use security controls to limit users’ access to elements within a dimension. This can be done by setting a security group’s access…

In some cases, it is necessary for a file to be exported by Planning Analytics as needed by the users of the system. In most cases this is done by using the ASCIIOUTPUT command in a TurboIntegrator process. When the export uses a NumberToString() function to convert one of the exported values from a number…

For those of you in the Planning Analytics (PA) world – Have you used any MDX lately?  (MDX=Multi-Dimensional Expression).  The goal of this article is to help you spot additional opportunities for MDX to assist in everyday analysis, reports, and extracts out of a PA model.   This is a follow-on to an earlier Knowledge Base…

In this article we look into creating a dynamic server reference with PAFE workbooks so that they can be successfully opened across multiple instances. Read on to learn why we do this, how to set it up, best practices, and some troubleshooting tips. What is a Dynamic Server Reference? Planning Analytics for Excel worksheet functions…

TM1py is a free Python package that extends the functionality of Planning Analytics by integrating the TM1 REST API with Python allowing the use of Python libraries. TM1py enhances data source integration, enables machine learning using python, and facilitates Planning Analytics object control using Python automation. In a recent internal “Hackathon” a group of QueBIT…

When upgrading from TM1 10.2.2 to the newer Planning Analytics there are steps that need to be taken to be able to continue using TM1 10.2.2 Architect and Perspectives. The following steps outline what must be changed to support this functionality. Without performing these steps, the Planning Analytics server may not appear in the list…

A file with a latex extension (.tex) is a text-based markup language file created with the typesetting system known as LaTeX which can be used to define type settings for publications, letters, books, and other similar cataloging in various fields. Specifically, for academic publishing, LaTeX (pronounced “LAY-tech”) is a staple. But what is LaTeX? “…LaTeX is…