Posts by agoddard
Why 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 MoreHow Do I Add a Table of Contents to Cognos Analytics 11.1.x Reports to Improve Navigation?
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 MoreHow Do I Use Layout Component References in Cognos Analytics 11.1.x to Standardize and Reuse Report Components?
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 Do I Change an Element Name in TM1/IBM Planning Analytics Without Breaking Dependencies?
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 Do I Create Picklists in IBM Planning Analytics Using Dimension Attributes or 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 MoreHow Do I Add a TurboIntegrator (TI) Process or .pro File to an Existing TM1 (Planning Analytics) 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 MoreHow Do I Use the QueBIT Standard TurboIntegrator Process to Clean Up Data, Manage Subsets, and Create 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