• 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 & Reporting

Webinar: How to Reforecast Effectively & Quickly in Uncertain Times

April 3, 2020 by Lisa Minneci Leave a Comment

News & Events

These are uncertain times. All but essential businesses in many parts of the U.S. are now working from home. Retail establishments have closed. Manufacturing plants are being re-worked to adapt from making car parts and sneakers to manufacturing Personal Protective Equipment (PPE). Some industries are booming. Some are busting. And most just don’t know what the future holds.

Unfortunately, from a financial standpoint or an operational standpoint, you can’t ignore the changes that are happening to your business. The question is: how easily can you adjust your forecast to reflect these changes?

Join us on Wednesday, April 8, 2020 at 4pm EDT for a live webinar on agile forecasting. Lee Lazarow, our FP&A Technology Director, will present examples of how our clients use IBM Planning Analytics for forecasting and what-if scenario planning. You’ll hear how:

  • A retailer/manufacturer used a percent approach to adjust numbers while dealing with a shut down in production
  • A financial services company, which uses driver-based planning, updated their plan by changing their starting assumptions
  • A medical not-for-profit created a new high-level, driver-based model to reflect decreased donations of supplies and money

Whether you are looking for a better planning solution, or if you are already an IBM Planning Analytics client, you will learn something from this webinar. Our goal is for you to come away with an understanding of different approaches for more nimble and efficient planning.

Register today!

Home » Planning & Reporting » Page 8

Filed Under: News & Events Tagged With: Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, planning analytics webinar, reforecasting, Revelwood, scenario planning, TM1, what-if planning, what-if scenarios

IBM Planning Analytics Tips & Tricks Video: The Hold Feature

March 17, 2020 by Lee Lazarow Leave a Comment

Videos

Today’s IBM Planning Analytics Tips & Tricks video focuses on the new hold feature in Planning Analytics. Watch the video and you’ll see our Director of FP&A Technology, Lee Lazarow, demonstrate how to use the hold feature, which gives you the ability to do full top-down spreading or partial spreading.

In this video Lee will show you how to do top-down planning in Planning Analytics. He walks you through the simple scenario of decreasing all expenses by 10%. He also shows you how to set a fixed expense, but then also decrease your other expenses.

This is just one of many new useful features in Planning Analytics.

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:

IBM Planning Analytics Tips & Tricks Video: Using Words Instead of Numbers

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

IBM Planning Analytics Tips & Tricks Video: Filtering in Planning Analytics

Home » Planning & Reporting » Page 8

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, Planning & Forecasting, Planning & Reporting, TM1

IBM Planning Analytics Tips & Tricks: Using Words Instead of Numbers

March 3, 2020 by Lisa Minneci Leave a Comment

Video

In today’s IBM Planning Analytics Tips & Tricks video, our FP&A Technology Director, Lee Lazarow, demonstrates how you can use words to input data in Planning Analytics Workspace (PAW) instead of numbers. In the old TM1-world, you had the ability to put numbers into your system as part of your normal planning approach. Now, you can use words. Let’s explain …

Watch our Planning Analytics video and you’ll learn how to:

  • Enter words such as 2k to indicate 2,000
  • Enter 2.5K for 2,500
  • Use the “greater than” sign to spread values into other cells and reconsolidate them
  • Have Planning Analytics Workspace do the math for you by typing in common phrases such as “add 100” or “increase by 10%”

This approach gives you a great deal of flexibility when using PAW. You can use your number keypad, your standard keyboard, or even voice commands to enter data into Planning Analytics.

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:

IBM Planning Analytics Tips & Tricks Video: Reordering TM1 Cubes

IBM Planning Analytics Tips & Tricks Video: Filtering in Planning Analytics

IBM Planning Analytics Tips & Tricks Video: Creating Buttons in Planning Analytics

Home » Planning & Reporting » Page 8

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 video, Planning Analytics video, TM1

Adaptive Insights Scores Highest in Gartner 2019 Critical Capabilities Report in Three Use Cases

March 2, 2020 by Lisa Minneci Leave a Comment

News & Events

Adaptive Insights earned the highest scores in the Gartner 2019 Critical Capabilities for Cloud Financial Planning and Analysis Solutions report for lower midsize organization use cases, upper midsize use cases and for business unit use cases.

Gartner’s Critical Capabilities for Cloud Financial Planning and Analysis Solutions report examines the strengths of different vendors offering financial planning and analysis solutions as it relates to specific use cases. The goal of the research is to help organizations assess products and compare products that most closely meet their business needs. Overall Gartner found that many of the vendors covered in the research “improved year-over-year scores in critical capabilities.” The report continues, “this indicates that maturity levels and satisfaction associated with cloud offerings in this market are rapidly improving.”

Gartner’s assessment of Adaptive Insights includes the following highlights:

  • Top quartile scores for ease of implementation
  • Top quartile scores for ease of use and maintenance
  • Top quartile scores for financial budgets and plans

Additionally, Gartner writes “Adaptive Insights improved its scores across all capabilities this year, with financial budgets and plans and IFP/modeling showing the largest improvements.”

Adaptive Insights Scores 4.40 out of 5.0 in Lower Midsize Organization Use Case

Gartner defines “lower midsize organization” as “small public or private organizations between $50 million and $250 million in annual revenue.”

Adaptive Insights Scores Highest in Gartner 2019 Critical Capabilities Report in Three Use Cases

Adaptive Scores 4.32 out of 5.0 for Upper Midsize Organization Use Case

An “upper midsize organization” is defined as “midsize public or private organizations with $250 million to $1 billion in annual revenue.”

Adaptive Scores 4.32 out of 5.0 for Upper Midsize Organization Use Case

Adaptive Insights Scores 4.34 out of 5.0 in Business Unit use case

This category is for business units in large organizations.

Adaptive Insights Scores 4.34 out of 5.0 in Business Unit use case

According to Gartner, the research “analyzes how successfully the selected vendors support FP&A processes, as well as the successes of their respective solutions in terms of use and adoption.” In addition to Adaptive Insights, the report includes Anaplan, BOARD International, CCH Tagetik, Host Analytics (now Planful), IBM, Jedox, Kaufman Hall (Axiom Software), Kepion, OneStream Software, Oracle, Prophix, SAP, and Vena Solutions.

Home » Planning & Reporting » Page 8

Filed Under: News & Events Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, Planning & Forecasting, Planning & Reporting

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 & Reporting » Page 8

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 & Reporting » Page 8

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 & Reporting » Page 8

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 & Reporting » Page 8

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 & Reporting » Page 8

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 6
  • Page 7
  • Page 8
  • Page 9
  • Page 10
  • Interim pages omitted …
  • Page 22
  • 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.