Posts by agoddard
Why you need a Process Statistics Cube in Planning Analytics
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 MoreCreating a Dynamic SQL Statement in Planning Analytics Turbo Integrator
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 MoreThe Joy of Custom Controls in Cognos Reports Version 11.1.X
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 MoreAdding a Table of Contents in Cognos Reports Version 11.1.X
Don’t hunt and peck for your piece of the report, use a table of contents! A table of contents, sometimes headed as Contents or abbreviated informally as TOC, is a list usually found on the first page of a report. It includes section titles or brief descriptions with their corresponding page numbers. When running a…
Read MoreLayout Component References in Cognos Reports Version 11.1.X
How to use a Layout Component Reference, and override components when necessary! One of the main struggles report authors face is the maintenance of production reports. It’s not enough to just create the report, one must also ensure the report is updated as changes are made to corporate privacy notifications, colors and logos. This is…
Read MoreHow to Change an Element Name in TM1/IBM Planning Analytics
Is your element name wrong? Wish you could update a misspelled, incorrect or changed element name in your TM1/Planning Analytics model? Here’s the solution! Create an alias with all the updated names for all elements. It might be a good idea to name this alias “Old Name” or “Original Name” since once the swap occurs,…
Read MoreMastering the TM1 DBRW Excel Function
How to Create TM1/IBM Planning Analytics Picklists with Dimension Attributes or with Rules
Picklists are a beloved feature in TM1/Planning Analytics (PA) as it helps prevent user input errors, by limiting the values that can be typed into a cell. How to Create a Picklist in TM1/PA using Attributes: Create an attribute off any given dimension and name it “Picklist.” Write the element attribute names. In this example,…
Read MoreAdd a TurboIntegrator (TI) process (.PRO) file to an existing TM1 server
Introduction TurboIntegrator (TI) is the built-in ETL (Extract, Translate and Load) tool for the TM1 Server technology that powers IBM Planning Analytics. TI’s functional units are referred to as TI processes or scripts. TI processes can be used to perform a wide variety of tasks including: Loading data directly from a relational (ODBC) data source…
Read MoreQueBIT Standard TurboIntegrator process: Cleanup Subsets and Views
QueBIT standard TurboIntegrator (TI) processes are used on IBM Planning Analytics (powered by TM1) implementation projects to accelerate the development process and reduce implementation costs. They are included at no charge to QueBIT clients. This note documents the QueBIT – Cleanup Subsets and Views TI process. Click here to download it. Functional Description This TI…
Read More