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…

Whether you are building a new model, adding objects to an existing application, or simply maintaining a Planning Analytics solution, there is opportunity to automate the creation of standard subsets. This can be done via TI process and be applied to all the Dimensions within the model. This ensures that subsets are configured consistently across…

I have often found myself rewriting the same command line scripts to parse through the Planning Analytics data directory.  Here are a few common use cases for doing so: 1) Checking dependencies of objects a. Ex. Without opening all the chores, how can I confirm which chore runs the process “Cube – Finance – Load…

There are several design considerations when building dashboards, such as presenting information in a clear and concise manner, ease of navigation, and usability.  Additionally, adding customizations to match your company profile and brand will help to embed analytics within your organization and provide a seamless transition from other applications with a matching look and feel.…

Snowflake is a data warehouse, and it has gained a lot of popularity in recent years. Organizations choose to store and process their data in Snowflake which is a great data platform. Most organizations also need an analytics platform to build their forecast, perform ad-hoc analysis, and create dashboards. IBM Planning Analytics (Cloud) is an…

An allocation model is commonly used in a planning and budgeting process. A simple allocation model distributes an amount, such as expenses, to different segments of a business. The segments can be cost centers, departments, sales teams, etc. An example of a simple allocation model is an IT allocation model which allocates the total IT…