Posts by agoddard
How 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 MoreHow Do I Use a TurboIntegrator Process to Build a Dimension Hierarchy in IBM Planning Analytics?
In this article we look into the sources and functions necessary to build a dimension’s hierarchy using an IBM Planning Analytics Turbo Integrator [TI] process. Read on to learn how to set it up, some best practices, and some troubleshooting tips. What TI functions are used to create hierarchy in a dimension? DIMENSIONELEMENTINSERT() and DIMENSIONELEMENTCOMPONENTADD()…
Read MoreHow Do I Use the ELISANC Function in TurboIntegrator for IBM Planning Analytics and What Does It Do?
ELISANC is one of the more versatile functions in Planning Analytics. The function determines whether the first element is an ancestor of the second element. This function returns 1 if the relationship is true, and it returns 0 if the relationship is not true. Although ELISANC can be used in rules and TurboIntegrator (TI), we…
Read MoreHow Do I Use the ASCIIOutput Function in IBM Planning Analytics and What Are Common Use Cases?
The ASCIIOutput function creates a comma-delimited record in an ASCII output file. This function is a TurboIntegrator function and it can be used to export data, debug a TurboIntegrator process, or generate an ASCII file for many purposes. This article will show the syntax of this function and some examples of its arguments. In addition,…
Read MoreWhat Is the Difference Between ELPAR and ELCOMP in IBM Planning Analytics and How Are They Related?
The short answer is Yes! These are invaluable elemental information functions within Planning Analytics. These functions can be used in Rules, Worksheets, and TI Processes. ELPAR and ELCOMP are very similar to one another and have other related functions which can return information about how elements reside within dimensions. In this post, I will discuss…
Read MoreWhat Changed in MDX Subset Evaluation in IBM Planning Analytics 2.0.9 and How Does It Affect My Queries?
Planning Analytics Changes to MDX Subset Evaluation in 2.0.9 July 2020 UPDATE: IBM has reverted the change described in this article in release 2.0.9.2 of Planning Analytics (PA), which is now available to Local and IBM Cloud customers. Additional background and information about this issue, and the fix by IBM, can be found in this…
Read More