IBM
A Database Administrator Approach to Building Cubes in IBM 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 MoreUpgrading PAW on Linux with 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 MoreIBM Planning Analytics Version History
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 to 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 MoreBuilding 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 MoreSparklines in Planning Analytics (without 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 MoreDemystifying the PA / PAfE / PAW / PASSL Install Files from IBM Fix Central
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 MorePlanning Analytics Workspace Security
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