IBM
How 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 MoreQueBIT Standard TurboIntegrator process: Publish 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 MorePlanning Analytics Local, Workspace, and Excel Download Guide
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 MoreUpgrading Planning Analytics Workspace (PAW) on a Linux Machine
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 MoreWhat Can a List Header and Footer Do for you 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 MoreCreating Professional PAW Dashboards
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