IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1
Did you know IBM Planning Analytics Workspace (PAW) gives you many options for showing data in charts? Here are some tips and tricks for working with charts in PAW. Scatter Chart vs Bubble Chart A scatter chart is used to show relationships…
January 10, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: DefineCalc
IBM Planning Analytics for Excel (PAx) version 80 introduced a new function called “DefineCalc." This function allows a user to create a custom calculation using TM1/Planning Analytics data via the use of MDX. There are a series of parameters, and the key…
January 3, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Top 3 Blog Posts of 2022
What was your favorite IBM Planning Analytics Tips & Tricks blog post in 2022? We did some analysis and determined the three most popular PA Tips & Tricks blog posts. They are: 1. IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based…
December 27, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos
The Revelwood team has created many IBM Planning Analytics Tips & Tricks videos. Which ones made it into the top 3 with the most views on YouTube? [Drumroll please!] They are (in order of the most views): 1. Shortcuts in PAW Models…
December 20, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER
A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing,…
December 13, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel
Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up action buttons in IBM Planning Analytics for Excel (Pax). In this video, Dillon shows your three approaches: …
December 6, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace
Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up synchronizations in Planning Analytics Workspace (PAW). In this video, Dillon walks you through how to: Change an…
November 29, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel SEQUENCE
Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in…
November 22, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process
Sometimes your TurboIntegrator scripts can become very long. While it’s nice to be able to scroll up and down throughout your code, there are times that you may want to go directly to a specific line. IBM Planning Analytics Workspace (PAW) version…