• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Financial Performance Management

IBM Planning Analytics Tips & Tricks: PAW Pass Context

August 4, 2020 by Dillon Rossman Leave a Comment

Tips & Tricks

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 everything on your sheets is synchronized. This is as easy as going to the synchronization properties of any views, visualizations, etc. on your sheets and enabling “synchronize dimensions.”

IBM Planning Analytics Tips & Tricks: PAW Pass Context

To enable “pass context,” navigate to the properties of your button and select “Button target.”

IBM Planning Analytics Tips: PAW Pass Context

Under “Other book” simply enable “Pass context.”  Your button will now pass selections made from book to book.

IBM Planning Analytics Tricks: PAW Pass Context

This allows you make a selection in one book, such as a year, and then carry it over to another book.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Swap Rows & Selectors in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: Learn to Use Snap Commands in Planning Analytics

IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Change Connection used by Quick Report

July 28, 2020 by Thanh Chau Leave a Comment

Tips & Tricks

When working with IBM Planning Analytics templates in Excel, there may be instances where you need to change the instance that the cube references to pull or send data. In Perspectives, updating the source was as simple as updating the first parameter of the DBRW or DBRA formulas.  However, Quick Reports do not use formulas so there is a different approach to update the connection.

In the Quick Reports section of the Planning Analytics ribbon, click on the Properties icon.

IBM Planning Analytics Tips & Tricks: Change Connection used by Quick Reports

In the top section of the resulting window, you will see the connection detail for the selected Quick Report. Click the Update button to make changes to the connection.

How to change connection used by quick reports in IBM Planning Analytics

In the next window, select the Admin Host from the dropdown menu at the top labeled “System”.  Expand the instances to view the cubes available in that instance and select the cube you want to use as the new source.  When you click OK, the source will be updated.

Learn how to change connection used by quick reports in IBM Planning Analytics

This approach offers an easy way to use the same files across multiple environments.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Edit Action Button

IBM Planning Analytics Tips & Tricks: Bulk Load Template for Cubes with Indices

IBM Planning Analytics Tips & Tricks: Comparing Sandboxes

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

FP&A Done Right: FP&A Tips for Scenario Modeling During COVID-19

July 24, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Adaptive Insights, written by Steve Dunne. It is a unique Q&A with Kinnari Desai, Workday’s senior director of corporate finance, on how Workday responded to the FP&A impact of COVID-19.

Kinnari Desai, Workday’s senior director of corporate finance, has deep insight into scenario modeling and how Workday approached this following the outbreak of COVID-19. We spoke with her to get more best practices and tips for financial planning and analysis (FP&A) teams.

How did Workday have to adapt its business planning process following the start of the crisis?

We were coming off the back of our annual planning cycle and thanking our teams for their efforts in delivering “Plan A.” Then of course, everything changed with COVID-19. We had to spring right back into action, modelling scenarios in an environment that was so new—and seemingly changing hour by hour.

I believe that in an uncertain environment like this, it’s very important the FP&A team aligns with the leadership team, understands the context of what’s happening, and looks at a small number of relevant scenarios. It can be easy to get carried away producing several scenarios, but the goal is to provide the leadership with a range of likely outcomes and provide data, in a simple way, that would enable decision making.

In these situations, I’d imagine speed is of the essence, but you have to get it right if scenario modeling data is going to be valuable to your business leadership?

I do think it’s important to execute quickly, but in order to achieve our objectives, we had to be thoughtful in our approach.

As a business, you have to agree on your priorities. Are you going to focus on top-line growth, cash, the impact of employee relief programs, hiring pauses, and so on? Then you should consider the impact of those on the P&L and cash flow.

The next big thing is getting input from the business. While we are always in lock-step with our business partners since we can’t model in a vacuum, it’s more important than ever to meet with the operational business leaders, gather their perspectives, and understand what’s top-of-mind for them. You should be meeting with leaders multiple times to quickly narrow down focus areas that are a priority for them, such as support for employees, availability of equipment, and hiring direction.

From there, how do you start thinking about how you’ll use scenario modeling to drive decision making and elements such as forecasting?

In our case we had to adapt our scenario modeling frequency to help us make decisions faster. This impacts things like forecasting —we could no longer rely entirely on a monthly forecast process, so we adjusted the process slightly. This has led our FP&A team to a more continuous approach to planning, versus point-in-time or quarterly updates.

There are areas like revenue and cash that we are visiting on a weekly or even a daily basis. Then there are other areas that we may not review daily, but look at more frequently than before. We also discussed as a team that at times, the level of guidance we can give to other internal teams may not be as detailed or defined as it has historically been, since the situation is constantly evolving. As a result, we all need to remain agile.

Last but not least, we also identified drivers of large spend, and cost levers that can be pulled should the need arise.

Technology obviously plays a key part in enabling scenario modeling. Can you tell us a bit about how you used Workday Adaptive Planning to drive the whole process?

Part of our job is to provide a sense of calm amidst chaos, and the Workday tools and data model enabled us to do just that. We spun up different versions in Workday Adaptive Planning, and adjusted the drivers like new business and renewal rates for revenue. For expenses, for example, we tweaked the timing of hiring, and the related impact on other expenses like benefits and employee relations costs were updated right away since they are based on timing of hire.

We were able to leverage actuals data from Workday Financial Management into our forecasts. This enabled us to see the resulting impact on the P&L and cash flow right away. All in all, we were able to speed up the process and operate 50% faster versus using spreadsheets. And the ability to use one data model and driver-based forecasting was very valuable.

What is the magic number when it comes to scenario modeling?

We modeled three different scenarios, and I think that’s a good number to work with during a fluid situation like this. I strongly recommend for my friends and colleagues in FP&A that they don’t drive themselves crazy doing 15 different scenarios! We don’t know everything yet, and spinning up more scenarios isn’t necessarily going to provide the answers.

We aligned on three possibilities and reasoned why these are important. This allowed us to focus on what matters, keeping it manageable so important decisions can be made without data overload.

What would your advice be to other FP&A professionals looking at ways to improve their business planning models today?

I’d start with “over-communicate.” I really can’t emphasize enough the importance of communication. We’ve moved to a remote, digital world, so hallway conversations are no longer a possibility. We needed to ensure emails are not misinterpreted, so we checked in via Slack or had quick Zoom calls. We provided financial guidelines on how to operate in the near term and why these are key.

For publishing updated forecasts to finance, accounting, and lines of business, we heavily leveraged our management reporting capability in Workday. Keeping these stakeholders informed on the approach and current thinking, even when all decisions have not been made yet, goes a long way.

Educate the business as well as accounting. In a changing environment, accounting also needs to be informed of the latest plan so they know what to expect (actuals) relative to the plan. This helps them as they prepare for and move through a remote close —with confidence and in concert with FP&A. The business will also need guidance to understand the latest plan and take action accordingly. Keep an eye on the fundamentals of the business, and take this as an opportunity to rethink some of the processes and outputs.

And lastly, remain agile. As the market continues to shift, we will need to remain flexible so that we can continue to pivot as needed. This is not a one-time shift in light of COVID-19, but a new and more agile way of operating that will allow finance to continuously adapt to change.

This blog post was originally published by Adaptive Insights and appeared here.

Read more guest posts from Adaptive Insights:

FP&A Done Right: 3 Words for a COVID-19 World –“Flexible Budget Variance”

FP&A Done Right: What FP&A Must Do Differently to Make Planning a Success

FP&A Done Right: Modernize your Budget Process to Anticipate Change

Home » Financial Performance Management » Page 21

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, cloud financial performance management, COVID-19, Financial Performance Management, Planning & Forecasting, Planning & Reporting, scenario modeling, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Edit Action Button

July 21, 2020 by Thanh Chau Leave a Comment

Tips & Tricks

Action buttons in IBM Planning Analytics are a great utility that allow users to recalculate a sheet, navigate to another location, or run a TurboIntegrator process. As your models evolve, you may need to periodically revise your templates to maintain their functionality. This sometimes include the action buttons.

In Perspectives, updating an action button was as simple as right-clicking on it and selecting the Properties option. In Planning Analytics, the approach is a little different.

From the task pane, click on the tab labeled “Workbook.”

IBM Planning Analytics Tips & Tricks: Edit Action Button

This section will show you all the different Planning Analytics objects that exist in your workbook.  Expand the folder labeled “Action buttons.”

Edit action buttons in IBM Planning Analytics

The name of each action button will be prefixed with the sheet name in which it is located.  Find the action button that you’d like to edit, right-click it and select the “Edit” option.

Learn how to edit action buttons in Planning Analytics

This will open the properties window where you can make changes to the action button.

How to edit action button in IBM Planning Analytics

This approach will allow you to quickly edit all of your action buttons at the same time instead of having to navigate through your workbook and search for each button.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 2

IBM Planning Analytics Tips & Tricks: Creating Buttons in IBM Planning Analytics Workspace (PAW)

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Comparing Sandboxes

July 14, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Many of you know that you can create personal what-if scenarios in IBM Planning Analytics via the sandbox feature. This approach allows you quickly replicate an entire environment which includes all of the data, rules, input templates, and reports from your existing models. But did you know that you can also easily compare data from the various sandboxes? This is done by creating a virtual dimension that contains your sandbox elements.

Creating the virtual dimension is as simple as adding a setting into your Planning Analytics configuration called EnableSandboxDimension and setting the value to true. By default, this parameter is set to false. This is a dynamic parameter, so a server restart is not required to enable this setting.

Once enabled, your cube will now show a new dimension called “Sandboxes.”

IBM Planning Analytics Tips & Tricks: Comparing Sandboxes

You can add this dimension to your PAW books as a selector widget. Once added, you can synchronize your views and reports to the sandbox selector.

Comparing sandboxes in IBM Planning Analytics

This approach offers an easy way to check your data before submitting a sandbox entry back into the base model.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 2

IBM Planning Analytics Tips & Tricks: Using Words and Numbers Together

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning Analytics tips, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 2

July 7, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

In an earlier post, I showed how to merge a button onto an image in IBM Planning Analytics to create an easy-to-navigate user experience. However, as a developer I may forget which images are just images and which images contain buttons.

To get around this, I sometimes add small reminders to my images to let me know there are two things merged into a single image. In the previous post, I recommended changing the text to a blank value. This result gives you the house image below.

Merging icons and buttons in IBM Planning Analytics

However, if you change the text into something small (such as a period) then you can easily make it fit into part of the image.

Merging icons and buttons in Planning Analytics Workspace

To the end user, the house now looks like it has a door. But as a developer, I now know that there are two components … an image and a button.

Hiding “dots” in your image is an easy way for you to remember the components in your PAW pages.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1

IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon

IBM Planning Analytics Tips & Tricks: Using Words and Numbers Together

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, IBM Planning Analytics Workspace, Planning Analytics tips, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1

June 30, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

User experience is an important factor when designing any system. One of the most important aspects of the experience is the ease in which users can navigate from one page to another.

In situations where an IBM Planning Analytics Workspace (PAW) book has multiple sheets, the navigation is as easy as clicking on the applicable sheet at the top of the page (just like you would do in Excel). However, in situations where there are multiple books, the navigation may require the use of a button.

Buttons are easy to create via the icon at the top of the screen.

IBM Planning Analytics Tips & Tricks: Merge Icon and Button Invisible

The resulting button appears as a rectangle and can be formatted to change things such as the text, the color and the border.

Merge an icon in IBM Planning Analytics

But did you know that you can make your own button by merging an image with a button? For example, maybe you want a “home” button that looks like a house. You can do this by using an image from the shapes icon and formatting it to your desired color and size.

Learn how to merge an icon and a button in IBM Planning Analytics

You can then drag a button on top of the image.

IBM Planning Analytics: Learn how to merge an icon and a button

By changing the text to a blank value, the button becomes “invisible.” Users will then be able to click on the house to navigate back to the home page.

This approach offers an easy way to create an good user experience for navigation throughout your PAW books.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon

IBM Planning Analytics Tips & Tricks: Using Words and Numbers Together

IBM Planning Analytics Tips & Tricks: The Data Load Process

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM PAW, IBM Planning Analytics, IBM Planning Analytics Workspace, Planning & Forecasting, Planning & Reporting, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Excel’s FILTER Function

June 23, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever wanted to filter a list of data to look at a subset of the entire table? Many of you know that you can use the filter button within Excel’s data section to do this.

IBM Planning Analytics Tips & Tricks: The Excel FILTER Function

But what if you wanted to create a filter that users can change without having to navigate through ribbons? Did you know that you can do this using Excel’s FILTER function?

The FILTER function allows you to filter a range of data based on criteria you define. This allows you to create selector cells which can be used within a formula to filter the selected data. The function is written as follows:

FILTER (range, formula for inclusion, if empty)

  • The range consists of the entire table to be checked
  • The formula for inclusion consists of criteria to be filtered
  • The last parameter (optional) defines a value to be returned when no results are found

The example below shows a table on the left, an input cell, and the FILTER command in cell F5. In this case, the function is being used to look at the entire table (cells B3 through D11) and checking to see if the value in column B is the same as the value in cell G2.

Learn about Excel's FILTER Function

The formula for inclusion can use more complex approaches to check multiple values. This is done by using the multiplication operator as the “and” statement. The example below expands upon the first example by allowing the user to independently select both a state and a city.

IBM Planning Analytics Tips: Excel's FILTER Function

This functionality allows you to replicate Planning Analytics selector concepts into an existing spreadsheet.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function

IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula

IBM Planning Analytics Tips & Tricks: New Excel Feature – Map Charts

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function

June 16, 2020 by Lee Lazarow Leave a Comment

Tips & Tricks

Have you ever looked at a value on a report and wanted to know the formula that was used, even though you may not have access to the report? Have you ever wanted to easily include a formula as part of the report? Have you ever wanted to show people how complicated your calculation was as an attempt to get them to better appreciate you?

Well, all of this can be done in Excel with the use of a simple formula: FORMULATEXT.

The FORMULATEXT function is used to return a formula as a string. The single parameter of the function is the cell to be converted to text.

The following example shows the use of the formula in cell C6.

IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function

Not only can you now show your co-workers how complicated your nested-if formulas have become, but you can also end those recurring nightmares about your middle school math teachers who always said “show me your work” (ok, maybe that’s just me).

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: The Excel DATE Function

IBM Planning Analytics Tips & Tricks: New Excel Feature – XLOOKUP

IBM Planning Analytics Tips & Tricks: Excel’s IFS Function

Home » Financial Performance Management » Page 21

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Revelwood, TM1

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 19
  • Page 20
  • Page 21
  • Page 22
  • Page 23
  • Interim pages omitted …
  • Page 47
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.