IBM
How Do I Get Started Monitoring IBM 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 MoreHow Do I Monitor IBM Planning Analytics Databases to Track Performance and Usage?
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 MoreHow Do I Interpret the IBM Planning Analytics Database Activity Report to Monitor Server Performance?
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 MoreHow Do I Use the Planning Analytics Database Usage Visualization to Monitor Activity and Threads?
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 MoreWhat Are the Data Spreading Shortcuts in IBM Planning Analytics Workspace and How Do I Use Them?
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 MoreHow 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 MoreWhen Should I Use Qualified vs. Unqualified Rules in IBM Planning Analytics and What’s the Difference?
There are several factors to keep in mind when creating business rules in Planning Analytics. What are rules, you ask? Rules are dynamic calculations that enable analysts, department leads, and planners to transform their data into real-time insights. Rules are the secret sauce when reporting in PA, but with great power, comes great responsibility. Adding…
Read MoreHow Do I Use the “Save Data” Command to Persist Changes in a TM1 (Planning Analytics) Cube?
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 MoreHow Do I Create and Use Rule Regions in Planning Analytics Workspace to Organize My Rule Files?
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 MoreHow Do I Use Scripting to Manage and Apply Subsets in IBM 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