IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Max Number of ELSEIF
Most of you know the concept of an IF statement within TurboIntegrator IF (expression); statement1;ENDIF; … and most of you also know the concept of nested-IF statements IF (expression); statement1;ELSEIF (expression); statement2;ENDIF; … and most of you also know the concept of…
May 12, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: New Excel Feature – Map Charts
One of the new features in Excel is the ability to create Map Charts to compare values and show categories across geographical regions. If you have your own set of data to use skip to step 3. Otherwise, we can accomplish this…
May 5, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Sparklines
Are you familiar with Sparklines, a rarely used feature in Excel? What happens when you’d like to provide a visual representation of data but don’t necessarily want, or have the space, for a big chart? Sparklines may be a viable solution. To…
April 28, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Bulk Load Template for Cubes with Indices
Do you have cubes in your IBM Planning Analytics (PA) model that allow for planning with line item detail? The struggle you may come across in creating a template in Excel that automatically loads to the next available line is that such…
April 21, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video: Formatting Views in Planning Analytics Workspace
In today’s IBM Planning Analytics Tips & Tricks video, Lee Lazarow, our PF&A Technology Director, demonstrates how to format views in Planning Analytics Workspace (PAW). By using formatting, you will make your views easier to read so your users can spend more…
April 14, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon
IBM Planning Analytics pages are defined as “books.” Each book can have multiple components on it (a view, an image, etc.) and the book can contain multiple sheets. Most users create books by clicking on the “New” icon from the Welcome screen…
April 7, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating Multi-Level Dimensions
In today’s IBM Planning Analytics Tips & Tricks video, our FP&A Technology Director, Lee Lazarow, demonstrates how to create multi-level dimensions in Planning Analytics Workspace (PAW). This new feature allows you to build brand-new dimensions by simply dragging a file onto your…
March 31, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Admin Server Recycle
In your existing TM1 world, much of the administration is done via your computer’s operating system. Planning Analytics brings much of the administration into your environment via a web-based interface. This blog post explains how to do server recycle through the new…
March 24, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video: The Hold Feature
Today’s IBM Planning Analytics Tips & Tricks video focuses on the new hold feature in Planning Analytics. Watch the video and you’ll see our Director of FP&A Technology, Lee Lazarow, demonstrate how to use the hold feature, which gives you the ability…