IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Export Dim Structure
Have you ever wanted to export a dimensional structure to an ASCII based text file in IBM Planning Analytics Workspace (PAW)? PAW version 99 introduced the ability to export a dimension with a single click. To export a dimension, right-click on the…
December 17, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Selector Menu
You may already know that you can create a selector widget in IBM Planning Analytics Workspace (PAW) by simply dragging a context dimension outside your existing view. Once synchronized, this approach provides an easy way to create independent selectors that can be…
December 10, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Thumb Cell Formatting
Have you ever created an exploration in IBM Planning Analytics Workspace (PAW) and noticed the arrows at the beginning of your rows and columns? These are called thumb cells and are used as the equivalent of a “select all” button. For example,…
December 3, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Exploration Icons
Have you ever been in a situation where you wanted your users to reference an exploration or chart on your IBM Planning Analytics Workspace (PAW) page, but you didn’t want to give them full access to make changes? You can do this…
November 26, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Explorations and MDX
Have you wanted to learn how to use MDX to create a VIEW, but are not sure where to start? A great way to learn is by looking deeper into one of your PAW explorations. The “Edit MDX” button can be used…
October 22, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Process Indent Script Button
One of my favorite development quotes is from a man names Martin Fowler. He said, “Any fool can write code that a computer can understand. Good programmers write code that humans can understand.” There are many ways to approach the definition of…
September 24, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Workbench Go To Rule
Have you ever referenced a view in an IBM Planning Analytics workbench and then realized that you also want to look at the rules associated with the cube? You can do this by referencing the left side navigation to scroll through the…
August 27, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Enter Members Feature
Have you ever created an IBM Planning Analytics Workspace (PAW) exploration and then wanted to look at data that was not in your original set? You can open the set editor and follow the applicable steps, or you can instead simply type…
June 18, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Border Lines
The great thing about explorations is that data appears in a simple grid-like format. This allows you to easily look at your data in an easy-to-read format that is similar to an Excel spreadsheet. In the example below, it’s easy for your…