IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 1
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks we’ll be highlighting some of the most popular and interesting posts on Excel. IBM Planning Analytics Tips & Tricks: Excel…
February 14, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXTSPLIT
Have you ever needed to parse a text string into different columns in Excel? This is easy to do via the text-to-columns wizard, but what if you wanted to do this via a formula? The TEXTSPLIT function allows you to split a…
February 7, 2023
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…