IBM Planning Analytics Tips & Tricks
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: VSTACK_HSTACK
In a previous blog, I wrote about the ability to convert a list into a set of smaller lists (create a link to the WRAPCOLS blog). But what if you wanted to do the opposite? What if you wanted to merge a…
July 30, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Slow-Performing 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…
July 16, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Converting a Manual Process to TurboIntegrator 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…
July 2, 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: 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…