IBM
How Do I Build IBM Planning Analytics Cubes Using a Database Administrator Approach in Planning Analytics Workspace?
If you are more of a code-junkie at heart like me, or perhaps have come from a relational database background, you may want to think about the following concept. By now, you most likely understand how to build cubes using Planning Analytics Workspace (PAW). If not, you can have a look here. Similar to TM1…
Read MoreHow do I upgrade PAW on Linux using MobaXterm and QueBIT script files?
Upgrading PAW on Linux with MobaXterm and QueBIT Script Files Environment Setup: Obtain a Linux user ID user that has “sudo” rights Confirm with IT team that Linux install has all basic components including: i. yum-utils 11. unzip Note that Word may change a short hyphen to a long hyphen so be careful copying and…
Read MoreHow do I interpret the version history for IBM Planning Analytics?
When IBM rebranded TM1 to Planning Analytics, the versioning also changed. On the surface and on IBM’s Software Access Catalog and Fix Central, the IBM PA version downloads are listed as 2.X, but behind the scenes the server versions are listed as 11.X. The chart below will help with translating what PA version 2.X is…
Read MoreHow do I import a file for an IBM Planning Analytics Workspace (PAW) TI process?
With the latest IBM Planning Analytics PAW user interface, Modelers and Admins can import a CSV file as the Turbo Integrator (TI) Process data source, just like in the past using Architect. Within PAW’s left-hand Data Pane, right-click on Processes, then opt to “Create New Process.” Within the TI user interface, IBM instructs the Modeler…
Read MoreHow Do I Build an Open Source, Multitiered Application?
In software engineering, multitier architecture (or multilayered architecture) is an architecture in which presentation, application processing and data management are physically separated. Often you will see architectural diagrams depicting the three “tiers” as: The Data Tier (where information is stored in a database or file system) The Logical Tier (where processing commands are executed, logical decisions are made, and calculations may be…
Read MoreHow Do I Create Sparklines in IBM Planning Analytics Without Using Excel?
A sparkline is a tiny chart that provides a visual representation of data. You can use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Sparklines are typically positioned near its data for greatest impact. Google search and you’ll most…
Read MoreHow Do I Find and Download the Correct IBM Fix Central Install Files for Planning Analytics (PA), PAfE, PAW, and PASSL?
Finding the correct Planning Analytics download files from IBM Fix Central can be a confusing task. This guide will walk you through the steps necessary to identify the Planning Analytics [PA], Planning Analytics for Excel [PAfE], Planning Analytics Workspace [PAW], and Planning Analytics Spreadsheet Services [PASSL] files that you need for your system. 1 –…
Read MoreUsing Subsets in Excel Based TM1 Reports and Cube Views
IBM Planning Analytics – Report Building Tips
What’s in a SUBNM? If you’re learning to build Excel based reports in IBM Planning Analytics, it’s important to understand the core FUNCTIONS and features that drive the report. Several of these functions can be customized to provide flexibility in both format and content. (i.e. TM1RPTVIEW, TM1RPTROW, SUBNM, MDX) Today, we will focus on the…
Read MoreHow Do I Configure and Manage Security in IBM Planning Analytics Workspace (PAW)?
Security for Planning Analytics Workspace (PAW) consists of three main parts: users, groups, and roles. It is important to realize that these three objects are PAW specific and just give access to PAW objects (books/views/dimension editors etc.) and these users will need to be set up in the Planning Analytics (PA or TM1) side first…
Read More