IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel YEARFRAC
I often build models that define the fraction of a year for a given month. For example, January is approx. 8.5% of a calendar year (31/365) and September is approx. 11.5% of a working day’s calendar (30/260). But what happens in situations…
March 14, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 1
So many webinars, so little time! If you are like me, you probably receive invitations to webinars on a regular basis. Some of them even make it onto my calendar. Unfortunately, more often than not, I have the best intentions of attending…
March 7, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2
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. You can read part 1 here. IBM…
February 28, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel EOMONTH
Thirty days has September … Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of…
February 21, 2023
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…