IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Convert to Driver-Based Planning
This is the latest post in our blog series on how we solve problems. Each blog post focuses on a real-world client experience where Revelwood was presented with a unique or thorny problem. We’ll explain our approach to how we solved it.…
June 11, 2024

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s WRAPCOLS Formula
Have you ever needed to modify a list in Excel without wanting to manually manipulate the data? Excel’s WRAPCOLS formula lets you reshape data without having to perform tedious copy and pasting. The syntax of the WRAPCOLS formula is: =WRAPCOLS(vector, wrap_count, pad_with)…
June 4, 2024

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Fixing Repetitive Scripts
This post is the latest post in our new blog series: How We Solve Problems. Each blog post focuses on a real-world client experience where Revelwood was presented with a unique or thorny problem. We’ll explain our approach to how we solved…
May 28, 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: How We Solve Problems
This post is the first post in our new blog series: How We Solve Problems. Each blog post focuses on a real-world client experience where Revelwood was presented with a unique or thorny problem. We’ll explain our approach to how we solved…
May 14, 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: Asymmetrical Expand in PAW
Have you ever been in a situation where you have stacked dimensions in your view and only want to expand one section of it? In legacy Perspectives, an expansion of one area equates to an expansion of all areas. IBM Planning Analytics…
April 30, 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 and Tricks: Excel’s ARRAYTOTEXT Function
Have you ever needed to export Excel data in a format that can be read by other systems? Although csv files are widely accepted, many legacy systems expect data in an array format. This can be done using the ARRAYTOTEXT formula in…