IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 2
Did you know IBM Planning Analytics Workspace (PAW) gives you many options for showing data in charts? We recently shared a few tips and tricks for visualizing your data in charts. Here are some more. Pie Chart Sizing Did you know that…
January 31, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Make an MDX Statement Dynamic
Did you know we have a number of resources available to learn more about MDX? We hosted a two-part series on How to Use MDX in Your IBM Planning Analytics Series. We also published a blog post, IBM Planning Analytics Tips &…
January 24, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Approaches in Planning Analytics’ New Set Editor
In Revelwood’s latest IBM Planning Analytics Tips & Tricks video, Lee Lazarow demonstrates three different ways to change a drop-down menu in Planning Analytics’ new set editor. Watch this video to learn the three approaches: 1. Change the drop-down by doubling clicking…
January 17, 2023
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: …