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 MoreIBM Planning Analytics Business Rules: To Qualify or Not to Qualify? That is the Question.
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 MoreTM1 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 MoreCreating 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 MoreScripting 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 MoreDynamic Planning Analytics Server Names in PAX
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 MoreCreating Picklists in Planning Analytics
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 to speed up TM1 ODBC Output
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 MoreCreating Effective Source and Zero-Out Views in Planning Analytics
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 MoreTM1 Security Refresh – When to use it?
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