IBM
How 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 MoreWhy Should I Use a Process Statistics Cube in Planning Analytics and How Does It Help Monitor ETL?
Have you ever logged into your IBM Planning Analytics environment, seen a number and thought to yourself; I wonder when that was updated? Do you struggle to dig into the log files anytime something odd seems to have happened? Assuming the data changes occurred due to an automated process rather than manual changes, then building…
Read MoreHow Do I Build and Use a Dynamic SQL Statement in a Planning Analytics TurboIntegrator Process?
When using an ODBC data source for a Planning Analytics Turbo Integrator (TI) process, native TI parameters can be utilized within the SQL query. Planning Analytics users have the power to be more specific and efficient with a query, potentially increasing performance by having less unnecessary data that needs to be read throughout the process,…
Read MoreHow Do I Use Custom Controls in Cognos Analytics 11.1.x Reports to Enhance Interactivity and User Experience?
Here’s how to toggle between hiding and showing parts of a report Custom Controls, a new capability with release eleven, easily enables the report author to add Java Script to the report, thus providing an enhanced user experience when rendering the data in HTML. As long as the report is running in full interactive mode,…
Read More