• 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

Planning & Forecasting

FP&A Done Right: The Path to Great Reporting

February 28, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Workday Planning, written by Gary Cokins. Cokins discusses some of the challenges with traditional financial reporting processes.  

For FP&A, financial reporting is a tricky balancing act.

If you share too many reports, business leaders may give up reading them all together. They are saturated. In a study by the American Institute of CPAs and the Chartered Institute of Management Accountants, 32% of C-level executives said more data has made things worse, not better, for decision-making.

But if you offer bare-bones financial reporting, stakeholders scream for more relevant data and timely information. Case in point: That same survey found 70% of C-level executives saying at least one strategic initiative failed in the last three years due to delays in strategic decision-making. So how do you find the balance of not overwhelming your business partners while still getting them the information they need?

They need facts because in the absence of facts, anybody’s opinion is a good one. And usually the biggest opinion wins, which is likely managers at the top of the org chart. So to the degree they are making decisions on gut feel, intuition, flawed and misleading information, or office politics, an organization is at risk.

Here are three proven steps:

Step #1: Survey users

Your CEO needs access to different data than the manager of HR. Yet there’s also a good chance that they may be interested in some of the same information. And even within the same departments, managers may seek different information. Managers have varying requirements and goals; some prefer a very high-level overview, while others want specific information and a lot of granular details.

So what’s a finance team to do?

It sounds simple, but it begins with good communication. Talk to users and find out what they want and why they want it. Ask what types of decisions they will make with better information. Delve into how they would like reports presented and how often they need them. From time to time, follow up with a brief meeting or a simple survey to ensure that managers are using reports and if there is any new information that would be useful.

Of course, it’s essential to continue to make ongoing investments in technology that ensure you can deliver the reports that business partners are looking for in user-friendly formats. Technology investments not only save FP&A time—which allows for a more thoughtful and strategic approach to generating relevant reports—they also have a measurable impact on the bottom line. A study conducted by Nucleus Research found the average return from each dollar spent on analytics technology was $13.01.

Step #2: Customize dashboards

A key strength of technology investments is dashboard technology. Dashboards have revolutionized reporting, dramatically reducing the mountains of spreadsheets with racked-and-stacked tables that find their way to managers and department heads via email or hard copy. So make sure you are making the most of the technology by working with users to customize dashboards so they can access the reports they want and in a format that is most useful to them.

A customized dashboard allows managers to do a better job by measuring and monitoring performance as well as proactively shaping business outcomes through real-time awareness of financial and sales data. Dashboards are also a powerful tool to track your company’s actual broader performance against your planned expectations and goals, year to date.

When it comes to dashboards, a quick demo can go a long way. You can show users the power of data visualization presented in a range of formats from standard bar, column, or doughnut charts to more engaging funnel, waterfall, and bubble graphics. And you can demonstrate how they can generate their own reports to gain even further insight into their team’s performance and how it impacts the entire organization.

These visualization tools have proven to be game-changers in terms of making reports accessible and understandable to a wide range of users. As a TechTarget writer recently pointed out: “Without (data visualizations), analytics teams are engaging in a nearly impossible task that’s tantamount to flying an airplane while blindfolded.”

Step #3: Track results

It’s often said that what gets measured gets done. It’s also often said that if you cannot measure it, you cannot manage it, and if you cannot manage it, you cannot improve it. With that in mind, one way to ensure that relevant reports are being generated is to assess whether they are leading to measurable results.

Have reports resulted in greater efficiency, changes in behavior, or an uptick in sales and profits? Internally, are the reports helping drive collaboration and more insightful conversations? If not, why? You may need a deeper dive into whether the right information is getting into the right hands at the right time.

Opening lines of communication with business partners is key. Discuss targeted outcomes and then identify the reporting—or tweaks to reporting—that will provide the real-time data and insights to drive better results. Adaptive Insights customer Cumulus Media successfully applied this approach, instituting self-service reporting so users across the organization can create and run reports on demand. The result: It now takes just seconds—not days—to access and analyze business performance data relevant to each manager.

Finally, celebrate and highlight success. If a certain department is delivering big wins by leveraging insights from the reports it is receiving and generating, then promote and broadcast that throughout the organization. Success will breed success.

Good reporting leads to better results

Of course, it’s important to remember that when it comes to reports, finance should be a facilitator and strategic partner, not a hand-holder. Managers need to be self-sufficient. But it’s important to put the relevant information in their hands so they don’t have to track down finance every time they have a question.

Ultimately, good reporting leads to better results. By identifying and delivering the reports that leaders and managers throughout your organization need, FP&A can make a big impact and solidify its role as a strategic business partner. Finance has the opportunity to expand from bean counters to bean growers.

Gary Cokins is an internationally recognized expert, speaker, and author in enterprise and corporate performance management (EPM/CPM) systems. He is the founder of Analytics-Based Performance Management LLC. Gary can be reached at gcokins@garycokins.com

This blog post was originally published on the Workday Adaptive Planning blog.

Home » Planning & Forecasting » Page 12

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, dashboards, Financial Performance Management, financial reporting, Planning & Forecasting, Planning & Reporting

What’s the Total Economic Impact of IBM Planning Analytics?

February 24, 2020 by Lisa Minneci Leave a Comment

News & Events

When potential clients are evaluating IBM Planning Analytics as a budgeting, planning and reporting solution, they often ask us for its ROI. It’s not a simple question to answer. Every organization’s business situation, and needs are unique to them. The corresponding implementation is as well. As a result, there’s really no universal ROI for any given software solution.

A Forrester report helps provides some related information for businesses looking at Planning Analytics. IBM and Forrester recently came out with The Total Economic Impact™ of IBM Planning Analytics. The analyst firm used its Total Economic Impact (TEI) framework and methodology for the report, which serves “to provide a complete picture of the total economic impact of purchase decisions.” The findings are based on interviews with four customers with significant experience with IBM Planning Analytics, and with IBM executive and Forrester analysts.

The Total Economic Impact of IBM Planning Analytics

Based on the report, the total economic impact of Planning Analytics include:

  • 63% less time spent to complete the annual budgeting cycle
  • 80% faster processing planning data
  • 70% fewer labor hours required to complete forecasting cycles

Learn more about the key findings in the report and the benefits of Planning Analytics.

Read additional analyst reports that cover IBM Planning Analytics:

Revelwood Partners Adaptive Insights and IBM Earn High Ratings in BPM Partners’ BPM Pulse Survey

Excel Users Embrace IBM Planning Analytics

Independent Survey Ranks IBM Planning Analytics Against Competing Products

Home » Planning & Forecasting » Page 12

Filed Under: News & Events Tagged With: Budgeting, budgeting software, Cognos TM1, Financial Performance Management, Forrester TEI report, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, TM1

IBM Planning Analytics Tips & Tricks: How to Reorder TM1 Cubes in Planning Analytics Workspace

February 18, 2020 by Lisa Minneci Leave a Comment

Videos

In today’s IBM Planning Analytics Tips & Tricks video, our PF&A Technology Director, Lee Lazarow, demonstrates a new feature in Planning Analytics Workspace (PAW) version 2.0.44, that enables you to reorder TM1 cubes. Your TM1 cubes were likely designed for a specific reason. Over the course of years, the data has been changed and added to. TM1 would let you optimize the system by reordering the dimensions and re-indexing the database.

Watch this Planning Analytics video to see how this new feature lets you optimize your cubes by reordering them. When you reorder your cubes, PAW gives you information about the optimization, including if there will be an increase or decrease in performance, and what the impact on RAM will be.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip! And don’t forget to subscribe to our YouTube channel for more Planning Analytics videos.

Watch more Planning Analytics video tutorials:

Filtering in Planning Analytics

Creating Buttons in Planning Analytics

Planning Analytics Admin

Home » Planning & Forecasting » Page 12

Filed Under: IBM Planning Analytics Tips & Tricks, Videos Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, lee lazarow, planing analytics video, Planning & Forecasting, Planning & Reporting, Planning Analytics Tips & Tricks, planning analytics tips & tricks video, Revelwood, TM1

IBM Planning Analytics Tips & Tricks: Rule Timestamps

December 10, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

TM1’s print report wizard still exists in Perspectives and many clients continue to use this approach. I recently came across an issue where a client wanted to “burst” a report and include a time stamp on a report that is being snapshot (e.g., set the cells to contain actual values and not TM1 functions that retrieve values).  Easy peasy … just use the =NOW function to generate a time stamp. Right?

Wrong. =NOW is not a TM1 formula. This means that the cell will not get converted and the timestamp would therefore refresh each time the report was opened/refreshed.

Ok, no problem. We can create a numeric value in a control cube that uses TM1’s NOW function. The time stamp will refresh each time the cell is referenced and we can then zap that value. Again, easy peasy. Right?

Wrong again! TM1 only refreshes numeric rules when the rule is re-processed. In order to keep updating the result (e.g., show the current time and date), the user would need to reprocess the rule each time.

Again, no problem. TM1 may not re-evaluate the numeric value, but it will re-evaluate a string rule like this each time the cell is queried. So we can just switch this into a string value and simply use a STR formula against the NOW command. Right?

Wait for it … wait for it …

Wrong once more! Remember that date stamps within TM1 and Excel vary by 21,916 days (well, maybe). As a result, we need to add these days to the formula. The end result gives us a formula that uses a combination of STR, NOW, 21916, lots of digits and decimals, and a trim of the wasted space.

IBM Planning Analytics Tips & Tricks: Rule Timestamps

… and this end result gives the client the ability to have a time stamp using a TM1 formula that can be snapshot and then converted into a date format!

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! Or, sign up to get our Planning Analytics Tips & Tricks delivered directly to your inbox!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: New Configuration Settings for Dates

IBM Planning Analytics Tips & Tricks: Writing Rules

IBM Planning Analytics Tips & Tricks: Rule Concepts that are Often Forgotten

Home » Planning & Forecasting » Page 12

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

IBM Planning Analytics Tips & Tricks: Trimming Picklists

November 26, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that IBM Planning Analytics includes a feature that helps trim the list of choices in a picklist as you type? There are many different ways to create picklists in TM1/Planning Analytics and Revelwood has previously written about creating picklist cubes.

Here is an exploration that uses a picklist. This list entails all base level elements of a dimension. As you can see, there are six options to choose from.

IBM Planning Analytics Tips & Tricks: Trimming Picklists

I can select a value by clicking on an element from the list, which is great when I have a small list like this. But what if I have hundreds of elements in the list? The list can quickly become hard to navigate.

I can instead type in the “Search” area. If I type the letter “F” then my list is reduced to the only elements that contain the letter F.

IBM Planning Analytics Tips: Trimming Picklists

You can see that the list does not just look at the first character … it instead looks at all characters. As another example, if I instead type the letters “ment” then the list will trim down to anything that contains these letters within the full string.

IBM Planning Analytics Tricks: Trimming Picklists

This approach can help your end users when selecting cost centers, employee names, or other long lists.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Learn more about picklists in IBM Planning Analytics:

IBM Planning Analytics Tips & Tricks: Creating TM1/Planning Analytics Picklist Cubes

IBM Planning Analytics Tips & Tricks: When to Build Multiple Cubes

Home » Planning & Forecasting » Page 12

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

IBM Planning Analytics Tips & Tricks: Simplifying Dimension Maintenance

November 19, 2019 by Lisa Minneci Leave a Comment

Videos

Watch our latest IBM Planning Analytics Tips & Tricks video to learn how to simplify dimension maintenance in Planning Analytics. Once you master these easy techniques, you’ll be able to do all of your dimension maintenance from the Planning Analytics Workspace (PAW) administration screen.

In this video, Lee Lazarow, Revelwood’s FP&A technology director, demonstrates how to maintain your dimensions in PAW. Lee shows you how to move elements using both a standard drag-and-drop approach and a wizard-based approach. You’ll also see how to create new hierarchies and how to manipulate your dimension structure without going to a different screen.

By merging all aspects of a dimension together, you can do all your dimension maintenance from the PAW administration screen.

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!

Want to get our Planning Analytics Tips & Tricks delivered to your inbox every Tuesday? Sign up to get our weekly email of just the week’s tip!

Check out our IBM Planning Analytics Tips & Tricks video series:

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Snap Commands in IBM Planning Analytics

Pivoting & Selecting Shortcut in IBM Planning Analytics

Home » Planning & Forecasting » Page 12

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

IBM Planning Analytics Tips & Tricks: PAx Control Objects

November 12, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

IBM Planning Analytics uses cubes to store metadata information such as security and attribute information. These automatically generated cubes are called control cubes (which I sometimes call “squiggle cubes”) and begin with a prefix of a right curly brace.

Server Explorer used a toggle approach within the View menu to allow users to either view or hide these cubes. Planning Analytics for Excel (PAx) also includes a toggle approach that can be used via the following steps:

1) Ensure that the task pane is showing by selecting the icon within the IBM Planning Analytics ribbon

IBM Planning Analytics Tips & Tricks: PAX Control Objects

2) Click on the icon for “show and hide”

Understanding PAx Control Objects - IBM Planning Analytics Tips & Tricks

3) Select the option for “show control objects”

How to use PAx Control Objects - IBM Planning Analytics Tips & Tricks

Once selected, the list of cubes will expand and will display the control cubes. This list can be controlled via cube security to limit which control cubes can be seen by the user.

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: Troubleshooting Planning Analytics for Excel (PAx)

IBM Planning Analytics Tips & Tricks: The Ranked Report

IBM Planning Analytics Tips & Tricks: The Replace and Close Feature in PAx

Home » Planning & Forecasting » Page 12

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

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

October 29, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know Excel has a new feature called XLOOKUP?

For those of you who read these blogs regularly, you know that much of the focus is placed on IBM Planning Analytics Tips & Tricks.  However, I periodically also like to pass along new information about other planning and reporting aspects that impact your day-to-day tasks.

The VLOOKUP function has been around since Excel released version 1.0 in 1985. While VLOOKUP is one of the most widely used functions in Excel, there are some limitations:

  • Finding an “approximate” match
  • How to easily add columns in the search range
  • Define a search value in the middle of the range (e.g., not as the first column)
  • Starting a search at the bottom of your list without having to re-sort the data table

Microsoft recently announced the addition of a new function called XLOOKUP that is designed to simplify the lookup approach while merging functions such as VLOOKUP, HLOOKUP, INDEX and MATCH into a single function. The function is written as:

XLOOKUP(lookup_value,lookup_array,return_array,[match_mode],[search_mode])

lookup value: the value you are looking for (the same as VLOOKUP)

lookup_array: the lookup column (the same as VLOOKUP)

return_array: the results column (the same as VLOOKUP)

match_mode: This is an optional parameter that determines what kind of match to find.  The options include an exact match, an exact match or the next smaller item, an exact match or the next larger item, or a wildcard search.

search_mode: This is an optional parameter that allows you to determine whether the search happens from first-to-last or from last-to-first.

This new approach will make searching easier by not having to repeatedly modify your search table while also adding new functionality for tasks such as looking up a tax rate within a range of results.

There are many instances where the inclusion of Excel functions can help further your analytics. XLOOKUP is just one example.

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!

Home » Planning & Forecasting » Page 12

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Analytics, Beyond Budgeting, Budgeting, Budgeting Planning & Forecasting, Excel, Excel tips & tricks, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, new excel feature, Planning & Forecasting, Planning & Reporting, Revelwood, TM1, XLOOKUP

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

October 22, 2019 by Lisa Minneci Leave a Comment

Tips & Tricks

IBM Planning Analytics has a feature, snap commands, that simplifies various routine tasks. In our latest IBM Planning Analytics Tips & Tricks video, Revelwood’s FP&A Technical Director, Lee Lazarow demonstrates how snap commands in Planning Analytics allow you to change computer jargon into natural language wording.

In this video, Lee takes you through an example looking at operating expenses. He explains how Planning Analytics has built-in intelligence that is smart enough to understand typos or give you a list of options.

Watch Snap Commands in IBM Planning Analytics and learn:

  • How to turn on snap commands in the Planning Analytics Workspace (PAW) ribbon
  • How to use simple snap commands
  • How to hide a column

Snap commands simplify Planning Analytics, making your life easier!

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!

Check out our IBM Planning Analytics Tips & Tricks video series:

Regions with Rules in IBM Planning Analytics

Bookmarking in IBM Planning Analytics

Home » Planning & Forecasting » Page 12

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 10
  • Page 11
  • Page 12
  • Page 13
  • Page 14
  • Interim pages omitted …
  • Page 17
  • 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.