
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel LET Function
Have you ever created a formula that repeats another formula within a cell? Did you know that this repetition may be slowing down your reports? For example, you may have a report where you want to pull IBM Planning Analytics data and…
September 8, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Control Space
Have you ever been deep in thought while writing a rule or a process only to realize that you forgot the parameters for a specific command? IBM Planning Analytics Workspace (PAW) has solved this dilemma by giving you the ability to determine…
September 1, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: New PAx Feature – Double Click
IBM Planning Analytics for Excel (PAx) contains a task pane that shows the cubes within your model. Double clicking on a specific cube expands the information associated with the cube, including public views, private views, and the dimensions. Version 49 introduced a…
August 25, 2020

FP&A Done Right: 3 Steps to Help you Plan for What’s Coming
This is a guest blog post from our partner Workday Adaptive Planning, written by Bob Hansen. Read it to learn why static planning no longer works and how to make your business agile. Throughout the world, businesses of every size are feeling…
August 21, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Home Button
IBM Planning Analytics Workspace (PAW) offers an easy to use navigation menu that will quickly allow you to navigate to any open book. This is done by clicking on the menu at the top, center of your screen. Here is a sample…
August 18, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Subset Control Dimension
Did you know that dimensions exist within IBM Planning Analytics that display your model’s public subsets? A dimension called }Subsets_<Dimension Name> is automatically created when a dimension is created. The elements of this new dimension are dynamically updated as permanent public subsets…
August 11, 2020

The Impact of COVID-19 on Lease Planning and Management
The COVID-19 pandemic has impacted almost every industry – and will continue to do so into the foreseeable future. Corporate real estate and the real estate investment trust (REIT) industry are examples that have gone from fairly predictable scenarios to areas that…
August 10, 2020

FP&A Done Right: Reforecasting in a COVID-19 World – Best Practices you Can Implement Now
This is a guest blog post from our partner Adaptive Insights, written by Bob Hansen. The article shares insights from Workday’s internal finance leaders on how they are adjusting to the impact of COVID-19. COVID-19 has hit the entire world with unprecedented…
August 7, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Pass Context
IBM Planning Analytics Workspace sheets allow users to add buttons. These buttons can be used to navigate to different sheets or books, or even run processes. But did you know you can “pass context” from one book to another? Before beginning, ensure…