Get Started Monitoring Planning Analytics Databases in the IBM Cloud

IBM Planning Analytics Administration includes the ability to monitor and administer your databases from the Planning Analytics Monitoring dashboard (as long as you have administrator access to use the dashboard). Note: This information applies to Planning Analytics running in the IBM Cloud Environment. First question, what exactly are we referring to when we say, “a…

Read More

More Monitoring Planning Analytics Databases

In an earlier post, we mentioned how IBM Planning Analytics Administration includes the ability to monitor and administer your databases, as well as your host environment, from the Planning Analytics Monitoring dashboard (as long as you have administrator access to use the dashboard). Note: This particular functionality is available in both local/on premise installations as…

Read More

Breaking Down the IBM Planning Analytics Database Activity Report

In earlier posts, we outlined how you can use the IBM Planning Analytics Monitoring dashboard within Planning Analytics Workspace (PAW) administration to track the health of your host environment as well as individual databases. In this post we aim to breakdown the detailed database activity report which is available when you click the database name…

Read More

Exploring the IBM Planning Analytics Database Usage Visualization

In previous blog posts, we discussed the IBM Planning Analytics Monitoring dashboard within Planning Analytics Workspace (PAW) administration, which can be used to track the health of your host environment as well as individual Planning Analytics (TM1) databases. In this post we want to dig deeper into the database activity report and specifically, the usage…

Read More

Data Spreading Shortcuts in IBM Planning Analytics Workspace

What do we typically mean when we say, “data spread”? Well, perhaps the simplest way to understand this concept is by thinking of it as the act of “applying data across a range” – say a period of time. Perhaps you expect expenses to total a certain amount for the year, but you need to…

Read More

How to Add and Configure an Action Button

Adding an Action Button To add an action button, click on the cell where you want the button to be placed, then go to the TM1 ribbon, and click “Action Button” A button is created, and the action button properties window will open.  Here you can define the button’s action properties. Action Button Actions: An…

Read More

TM1 Save Data to TM1 Cube Save Data

IBM has rebranded IBM Cognos TM1 to IBM Planning Analytics however the server is still referred to as the “TM1 Server”, hence references to TM1 in the rest of the article. Running a full TM1 Save Data to commit in-memory changes to disk locks up the entire model and depending on the size and number…

Read More

Creating Rule Regions

IBM Planning Analytics is great at performing many rule calculations across cells in a cube. Rules are useful for instant, calculated results in a cube based on user inputs. But as the number of rules against a Planning Analytics cube increases, the harder it can get to keep track of them all. Lots of rules…

Read More

Scripting and Subsets in Planning Analytics

Keeping track of both public and private subsets and views within a TM1 or Planning Analytics model is somewhat daunting since there has been no simple administrative function available to accomplish this task. There are, of course, some “for-sale” tools available as well as various shell commands that offer partial solutions but if you don’t…

Read More