IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total
Pie charts are a type of visualization known as composition. Composition charts are designed to show the parts of a whole. This is a great way to look at the pieces of total. For example, the branches in a region or the…
January 23, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXT Function
Have you ever merged text and a calculated number into a cell and saw that the format of the number was hard to read? The TEXT function in Excel lets you convert the number into a more professional format. The syntax of…
January 9, 2024
IBM Planning Analytics Tips & Tricks
Top Three IBM Planning Analytics Tips & Tricks Posts – 2023
What were your favorite IBM Planning Analytics Tips and Tricks blog posts this year? We took a look at our website analytics and found the top three posts of 2023 are (drumroll, please!) … IBM Planning Analytics Tips & Tricks: DefineCalc IBM…
December 19, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using the Subset Editor in Planning Analytics Workspace
In the past, manipulating subsets in IBM Planning Analytics Workspace (PAW) involved a convoluted process of copying, creating new sets, and pasting elements. The subset editor solves this problem. The subset editor enables you to perform multiple tasks with a single click.…
December 12, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Region Expansion
A while back I wrote a blog about regions within regions in IBM Planning Analytics. This approach allows you to make your rules easier to navigate and read when scrolling through many lines of code. As you create regions, you can expand…
November 28, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Determine when Users Logged in to Planning Analytics Workspace
Have you ever wanted to learn when a user last logged in to IBM Planning Analytics Workspace (PAW)? Or to generate a list of dates and times when users logged in? IBM Planning Analytics version 87 includes a feature to easily figure…
November 14, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Substitute Function
Are you familiar with the SUBSTITUTE function in Excel? The SUBSTITUTE function in Excel replaces one value with another. This is similar to the REPLACE function, but SUBSTITUTE provides more flexibility. The syntax of the SUBSTITUTE function is: =SUBSTITUTE(text,old_text,new_text,instance_num) Text: This is…
October 31, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Cell Security in Planning Analytics Workspace
In our latest IBM Planning Analytics tips & tricks video, Lee Lazarow, Revelwood’s IBM Planning Analytics practice lead, explains and demonstrates cell security in IBM Planning Analytics (PAW). Cell security is a critical aspect of data management, providing control access to specific…
October 17, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips and Tricks: Trusting the Directory where the Planning Analytics for Excel xll file resides
Have you ever received a notification from Excel stating that it was having an issue trusting the Planning Analytics for Excel (PAfe) Add-In? If so, you are not alone! From time to time, it seems Excel needs to be reminded that the…