IBM Planning Analytics Tips & Tricks
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…
October 3, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Process Error Logs
Do you know how to use IBM Planning Analytics Workspace (PAW) to access error logs from your TurboIntegrator (TI) processes? It’s as simple as a single click! To access your logs, right-click on the Processes node in the workbench and select the…
September 26, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Adding Images to Charts
Charts are an excellent way to use visuals to convey information. Did you know that you can increase the effect of charts in Excel by adding custom images? Consider this plain pie chart. We can insert a corporate logo to give the…
September 12, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3
Here are two more popular IBM Planning Analytics Tips & Tricks videos. Did you know we have an entire library of video tips & tricks for IBM Planning Analytics? The Aggregate Function In this video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates…
August 29, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Counting Hidden Rows in Excel
With a clever combination of formulas, you can have Excel calculate the number of hidden rows in a data set. This trick will work on both manually hidden rows and autotfilter hidden rows. There are two ways to count hidden rows, depending…
August 22, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 2
We’re continuing to highlight some of our most popular video tips & tricks for IBM Planning Analytics. Creating Buttons for TI Scripts In this video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how to create a button in Planning Analytics Workspace (PAW)…
August 15, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Performance Monitoring
IBM Planning Analytics contains a series of Performance Monitoring Control Cubes that let you record performance statistics for various aspects of your environment. In Perspectives, this feature was enabled by right-clicking on the name of the server. But did you know that…
August 8, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 1
Did you know we have a library of video tips & tricks for IBM Planning Analytics? Over the next few weeks we’re going to highlight some of our most popular videos for IBM Planning Analytics / TM1. Filtering in IBM Planning Analytics…