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…
May 21, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Identifying a Specific Dimension
Have you ever wanted to change (or delete) a dimension, but first wanted to know how this action will impact your model? IBM Planning Analytics Workspace (PAW) allows you to quickly identify all the cubes in a database that include a specific…
May 7, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Greenbar
Have you ever generated an IBM Planning Analytics Workspace (PAW) exploration and struggled to read the values in the grid? For example, how easy is it to define the travel cost for department 55 in the screenshot below? A few years ago,…
April 16, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW “Spacers”
Have you ever created an exploration in IBM Planning Analytics Workspace (PAW) that contains a lot of data and wish that you could separate the information? PAW allows you to insert blank rows and columns called “spacers” into your exploration. Here is…
March 19, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s ROUND Function
Most standard financial reports round to some form of a large value. For example, the report may show numbers in millions or rounded to the nearest 100,000. This is done in Excel via the ROUND function. The function has two parameters: =ROUND(number,…