IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER
A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing,…
December 13, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel
Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up action buttons in IBM Planning Analytics for Excel (Pax). In this video, Dillon shows your three approaches: …
December 6, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace
Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up synchronizations in Planning Analytics Workspace (PAW). In this video, Dillon walks you through how to: Change an…
November 29, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel SEQUENCE
Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in…
November 22, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process
Sometimes your TurboIntegrator scripts can become very long. While it’s nice to be able to scroll up and down throughout your code, there are times that you may want to go directly to a specific line. IBM Planning Analytics Workspace (PAW) version…
November 15, 2022
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…