IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Filtering in IBM Planning Analytics Editor
Did you know there are different approaches to filtering elements when defining a subset in the IBM Planning Analytics editor? Lee Lazarow, Revelwood’s FP&A technology director and IBM Planning Analytics practice leader, demonstrates some ways to filter elements in our latest IBM…
November 8, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Borders in Preview
IBM Planning Analytics Workspace (PAW) allows you to easily create selector widgets that can be used for updating the data in your PAW book. This is done by adding a dimension as a selector widget. You can edit the list of elements…
November 1, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace
IBM Planning Analytics Workspace (PAW) allows you to easily create buttons that can be used for navigation and to run TurboIntegrator (TI) scripts. This is done by dragging the Action Button widget onto the sheet. By default, the button appears as a…
October 25, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: MDX Syntax Explained
MDX enables you to query dimensions and cubes, lists of elements, data points, calculations, and more. The first step in learning MDX is to understand the syntax. Below is an example of an MDX expression that returns all elements of the product…
October 18, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Global Settings in Overview Area of Exploration
Do you know how to define your global settings in the overview area of an IBM Planning Analytics Exploration? Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how to manage and define these settings. Watch our latest IBM Planning Analytics Tips & Tricks…
October 11, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar
Do you regularly work with others that are in a different time zone? If so, how often have you heard your counterpart tell you to “just determine my time by adding X hours to yours.” And how often have you messed up…
October 4, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: New Filter Option in Set Editor
Did you know IBM Planning Analytics Workspace (PAW) update 76 introduced a new filter option in the set editor? Previously, you could create a filter or multiple filters and the set would show the members that meet the criteria for every filter.…
September 27, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: 21/21/21
Some of you may remember an Excel feature that we wrote about a while back, which explained how the DATE function will convert invalid dates into real ones. For example, DATE(2020,7,35) will be converted to August 4, 2020, since there are not…
September 20, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Beginning to Explore the Set Editor in Planning Analytics for Excel
The IBM Planning Analytics Set Editor is the equivalent to the TM1 Subset Editor for Architect and Perspectives, but with expanded functionality. Getting started with the set editor is as simple as double clicking on a dimension within your exploration. In this…