Posts by agoddard
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 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 MoreHow Do I Use Dynamic Planning Analytics Server Names in PAX to Simplify Environment Configuration?
The main difficultly when migrating a Planning Analytics for Excel (PAX) report or input template from one Planning Analytics (PA)/TM1 Server to another is making sure it will work across both servers. Every PAX function, like a DBRW or SUBNM, requires the cube name or dimension name be prefixed with the Server name that is…
Read MoreHow Do I Create Picklists in IBM Planning Analytics to Control Valid Input Values?
Creating Picklists in Planning Analytics Picklists in Planning Analytics are the best way to help control the inputs users can put into a cell. When users are doing inputs into a cell, the possibility for error can be high. Imagine a rule that takes a value from an input cube and puts it into a…
Read MoreHow Do I Improve TM1 ODBC Output Performance to Speed Up Queries and Data Extracts?
The IBM Planning Analytics (TM1) ODBCOutput function is used in TurboIntegrator (TI) script to execute a SQL Update or Insert query against an open ODBC data source. ODBCOutput is very useful but can be slow if exporting large numbers of records, especially in a cloud environment. A typical TI process that uses ODBCOutput will have…
Read MoreHow Do I Create Effective Source and Zero-Out Views in IBM Planning Analytics to Support ETL and Reporting?
When writing Data Load – Turbo Integrator Processes in Planning Analytics, it is essential that effective Source and Zero-Out Views are created to ensure a correct transfer of Data. In Planning Analytics, a View is a user-defined collection of data intersections of a specified cube. The data intersections of a view are made up of…
Read MoreWhen Should I Perform a TM1 Security Refresh in IBM Planning Analytics and Why Is It Important?
If you have ever had an issue with security before, chances are you have used the ‘Refresh Security’ function on your IBM Planning Analytics (TM1) server. It is usually the first thing someone suggests when they learn your security settings have not updated as expected, and you are not sure why that is. The ‘Refresh…
Read More