IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Add Color to Multidimensional PAW Charts
Did you know you can add color to your multidimensional charts in IBM Planning Analytics Workspace (PAW)? Adding colors can make your charts easier to read. Watch Lee Lazarow, Revelwood’s FP&A Technology Director, demonstrate how to add different colors to PAW charts.…
September 6, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating Control Objects from the Modeling Workbench
Did you know you can now create control objects in IBM Planning Analytics Workspace (PAW) with update 76? This includes control cubes, control dimensions, and control processes. Previously, creating your own control objects required a TurboIntegrator (TI) process. Now it can be…
August 30, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Garbage Memory
I recently had a customer ask me why Windows was showing a much larger memory footprint than what was expected (based on their cube sizes). After further analyzing their model, we saw a large amount of garbage memory … which led to…
August 23, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models
Did you know there are shortcuts you can use in IBM Planning Analytics Workspace (PAW) when creating new models? In legacy tools such as Architect, required that you create your dimensions, cubes, processes and chores one piece at a time. IBM Planning…
August 16, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Customizing Background Colors for Data and Header Cells
Did you know that update 76 of IBM Planning Analytics allows you to customize background colors for data and header cells within your Planning Analytics Workspace (PAW) views? To customize these colors, click on a view within a page in PAW and…
August 9, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Adding and Editing Connection URLs in Planning Analytics for Excel
Do you know how to add a new Connection URL or Edit an existing Connection URL in Planning Analytics for Excel? Here are the steps to follow: Adding a Connection URL Once Planning Analytics for Excel has been launched, go into the…
August 2, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel DELET Function
A while back I wrote a blog about the SCAN function which showed how you can search for specific characters and then combine this with the SUBST formula to create new sets of text. But what if you wanted an easier way…
July 26, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Show Totals
One of IBM Planning Analytics’ purposes is to serve as an aggregation tool. As a result, many of your explorations consist of a series of base level elements plus a total. Here is an example of a simple exploration that shows details…
July 19, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel MAXIFS and MINIFS
Many of you know that Excel’s MAX function will define the largest value within a range. And many of you also know that Excel’s SUMIFS function will allow you to merge IF checks into your sum formulas. But did you know that…