IBM Planning Analytics Tips & Tricks
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…
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…