IBM
Creating Level-Based Row Indentation for Planning Analytics for Excel (PAfE) Reports
Level-based row indentation is a great way to add quick readability to your Planning Analytics for Excel (PAfE) reports. Instead of having a list of elements all left-aligned, we can add indentation based upon each member’s level to help report readers understand hierarchies within the dimension. Exploration Views, Quick Reports and Dynamic Reports all have…
Read MoreHow Do I Move Files to IBM Planning Analytics in the Cloud (PA Cloud) for Processing and Analysis?
You can use the IBM Secure Gateway to establish a secure connection between your on-cloud Planning Analytics environment and your on-premises data sources and easily move and manage data files in your on-cloud shared folder either remotely or directly within a desktop session on the IBM cloud. If you have multiple cloud environments, you can…
Read MoreHow 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 More