IBM
How 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 MoreHow Do List Headers and Footers Improve Your Reports in Cognos Analytics 11?
What Can a List Header and Footer Do for you in Cognos Analytics 11+ Just make your report look and read great! I recently had a client who wanted to see summary cost information on Sales Orders at the header of the page, with details available in a list report. I tried using singleton’s and…
Read MoreHow Do I Create Professional-Looking Dashboards in IBM Planning Analytics Workspace (PAW)?
Are you looking for professional ways to display your organization’s data within Planning Analytics Workspace (PAW)? Well, you have come to the right place! When illustrating your complex operational and financial data, it helps to have a clean and consistent budgeting and forecasting presentation to drive planning efficiency. The tips below offer quick ways to…
Read More