IBM
How 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 MoreHow Do I Use the QueBIT Standard TurboIntegrator Process to Publish a Private View as Public?
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 – Publish Private View as Public TI process. Click here to download it. Functional Description This…
Read MoreHow Do I Use the Planning Analytics Local Workspace and Download Data to Excel?
Planning Analytics Local, Workspace, and Excel Download Guide This download guide will walk you through the steps of getting the download package for Planning Analytics Local (PAL), Planning Analytics Workspace (PAW), and Planning Analytics for Excel (PAx) from IBM Fix Central. Please ensure that you have an active IBM ID as this will be required to…
Read MoreHow Do I Upgrade Planning Analytics Workspace (PAW) on a Linux Server?
IBM has adopted an AGILE development cycle and is releasing new versions of PAW Local approximately every 4-6 weeks. These PAW upgrades have been thoroughly tested and already released to IBM PA Cloud customers four weeks before they are made available for download, so there’s very minimal concern of any software issues arising. With these…
Read More