• 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

Professional Services Firms Need Future-Ready Forecasting

June 29, 2023 by Revelwood

FP&A Done Right

This is an excerpt from a blog post from our partner Workday Adaptive Planning. It highlights some approaches for professional services firms to keep up with the breakneck pace of work.

Professional services firms don’t have the luxury of gradually adjusting to an evolving digital environment. For them, the digital future is pretty much here. More than one-third of professional services firms expect that at least 75% of their revenue will come from digital by 2025, according to a report by PwC and Workday.

As an additional sign of the changing times, a growing proportion of firms are investing more than $50 million in artificial intelligence (AI), machine learning (ML), and advanced analytics, according to the report. And with recent advances in generative AI, investments are likely to continue to grow. That’s further blurring the line between professional services and digital services—a distinction that will only get fuzzier in the future. 

“Digital first is our new reality. That isn’t going to change,” shared Joe Golden, vice president of services, IBM, at a Workday event.

Yet, despite how adroitly many professional services firms adapted to wide-scale changes brought on by the pandemic, some lack visibility around past behavior and likely future outcomes. “Professional services organizations can be surprisingly opaque when it comes to insight,” IDC reports.

To succeed, firms must solve their data, talent, and technology challenges. But many have yet to embrace this new reality. Among professional services leaders, 57% say there’s a growing gap between where their business is and where it needs to be to compete, according to a recent Workday study on digital transformation. And only 23% say their digital strategy allows them to keep pace with or exceed the demands of the business.

Firms will need to bolster their access to high-quality, always-available data, along with having staff with the necessary data literacy skills to make sense of it all. Of companies with fully-accessible data, 76% say they are well-equipped digitally to ensure business continuity in times of crisis, Workday finds. Small wonder, then, that advanced analytics and data visualization are the skills most sought after by IT leaders (35%) and finance leaders (34%).

“Access to data is the crux of most technology issues in any company,” says Jennifer LaClair, CFO, Ally Financial.

To better understand what the future might hold for professional services firms, industry thought leaders shared their predictions for three of the biggest trends the industry will face. The following excerpt focuses on how professional services firms can benefit from more sophisticated forecasting.

Data Silos Disappear as Organizations Race to Future-Ready Forecasting and Adaptability

To drive productivity and profit and to forecast accurately, future-forward professional services firms will need more integration and less separation of their people and systems. “Today’s professional services organizations simply cannot operate with functional silos as the lines between sales, delivery, and finance become blurred,” SPI asserts.

Unfortunately, these organizations’ data too often sits trapped within silos. “The reason most companies can’t forecast their revenue more accurately is because they have different systems and data across their lines of businesses and services,” Joseph says. “And all those different systems mean that you have data that’s going to be wildly inconsistent.”

Almost half (49%) of business leaders—and almost two-thirds (62%) of professional services leaders—say their inability to connect operational, people, and financial data to business outcomes impairs the organization’s agility, according to a Workday survey of senior business executives. 

But firms with accessible data tell a different story, the Workday survey reveals. A towering 85% of leaders whose companies enjoy fully accessible data say the organization can embrace change readily. All of which points to the urgent need to overcome siloed data sources.

For ERPA, a consulting and enterprise application managed services firm, adopting professional services automation slashed the time needed to calculate revenue from a full day to just 15 minutes. And the firm gained a stronger forecasting ability in the process. 

“From week to week, we’re able to get a really good sense of our forecasted revenue for projects in the next four to 12 weeks,” says Jon Milkovich, director of Workday financials at ERPA. “So it’s really provided a lot better real-time insight into what our forecasted revenue will be.”

That’s a need that best-in-class firms are meeting head-on. They’re 82% more likely than other firms to be able to share financial and operational data with the extended enterprise through a central repository, Aberdeen finds in its report: “Leverage Demand Planning and Forecasting for Best-in-Class Performance During Volatile Times.”

Learn more about how professional services firms can adapt and change in our recent webinar, Streamlining Professional Business Services with Workday Adaptive Planning.

Read the full blog post on the Workday blog.

More from our FP&A Done Right Series:

Enterprise Planning Helps Professional Services Firms Adapt to Changes

FP&A Done Right: Trends in Accounting and Finance

Leveraging IBM Planning Analytics for xP&A

Home » Planning & Forecasting » Page 5

Filed Under: Finance Transformation Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, Planning & Forecasting, Workday, Workday Adaptive Planning

Revelwood Expands Best-in-Class Solution Portfolio to Include Incorta

June 14, 2023 by Revelwood

News & Events

We’re expanding our best-in-class solution portfolio to include Incorta’s open data delivery platform, giving our clients an analytics hub for the Office of Finance. Incorta’s technology simplifies the data ingestion and delivery approach, giving clients unrivaled data access to deliver fast, accurate insights.

“Savvy financial management can be hard to achieve,” said Tom McCrory, senior vice president, sales, Incorta. “It requires a rock-solid foundation of comprehensive data and ad-hoc, self-service analytics. Together, Revelwood and Incorta will help our join clients in the Office of Finance take the next step in providing strategic guidance to business operations.”

Incorta was recently included in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence (ABI) platforms. It was one of 20 vendors assessed in the report. Incorta directly maps to data sources, eliminating the need for data transformation, reshaping and aggregation required by other platforms.

“The Office of Finance has become a strategic asset for industry-leading organizations,” said Robert Gordy, CTO, Revelwood. “It’s no longer about managing the budget or performing basic accounting activities. Instead, the Office of Finance has evolved into managing all the disparate pieces of data to provide forward-thinking insights for the business. We’re partnering with Incorta to help CFOs and their teams move toward unlimited, active analysis.”

Additionally, Incorta has existing integrations with two of Revelwood’s technology partners – BlackLine and Workday Adaptive Planning.

Incorta and BlackLine

Incorta’s integration with BlackLine enables accounting teams to instantly drill-through to transaction details with a single click. It provides users the ability to access data from multiple ERPs and other source systems with easy, instant access to transaction-level details down to the subledger. By using BlackLine and Incorta together, clients benefit from:

  • A single source for all data
  • Transaction-level detail
  • Streamlined data flows

Incorta and Workday Adaptive Planning

Incorta’s integration with Workday Adaptive Planning accelerates and improves forecasting and planning with access to near real-time transaction-level data. The integration enables:

  • Automating operational analytics
  • Delivering transaction-level detail
  • Unifying enterprise data
  • Streamlining data flows


Learn more about our new partnership with Incorta!

Home » Planning & Forecasting » Page 5

Filed Under: News & Events Tagged With: BlackLine, Financial Performance Management, Incorta, Planning & Forecasting, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2

February 28, 2023 by Revelwood

Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks we’ll be highlighting some of the most popular and interesting posts on Excel. You can read part 1 here.

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

Have you ever wanted to define the number of working days between two calendar dates? Do you define “working days” simply as non-weekend days or do you also include holidays? Did you know that you can calculate this information using Excel’s NETWORKDAYS function? 

The NETWORKDAYS function is used to determine the number of whole working days between start_date and end_date. This blog post explains how to use it. 

IBM Planning Analytics Tips & Tricks: Excel TYPE Function

Have you ever referenced a list in Excel and needed to know whether each value was a number or a string? This may be required when another function depends on the type of value in each cell.

Excel has a function called TYPE that will give you this information. The function contains a single parameter, which is simply the cell you want to check. Learn more about using the TYPE function in this blog post.

IBM Planning Analytics Tips & Tricks: Excel OFFSET Function

Have you ever wanted to reference a cell based on its placement compared to another cell? Maybe you want to create a formula where each cell looks at the value 2 columns to the right or maybe you want to compare a value to the cell above. This information can be determined using Excel’s OFFSET function.

The OFFSET function is used to reference a range that is a specified number of rows and columns from a cell. We detail the syntax of the OFFSET function in this blog post. 

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 1

IBM Planning Analytics Tips & Tricks: Approaches in Planning Analytics’ New Set Editor

IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1

Home » Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

IBM Planning Analytics Tips & Tricks: Excel EOMONTH

February 21, 2023 by Lee Lazarow

Thirty days has September …

Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of February? More importantly, do you have to write complex logic into your spreadsheet to define this? If so, you may want to learn more about the EOMONTH function in Excel!

The EOMONTH function is designed to tell you the last day of a month – either the current month, a future month, or a historical month. The function has two parameters:

=EOMONTH(start_date, months)

  • The start_date parameter defines the initial date of your calculation
    • Microsoft recommends using the DATE function for this value
  • The months parameter defines the number of months from the start date
    • A zero value results in the current month
    • A positive value results in a future month
    • A negative value results in a previous month

Graphical user interface, application, table, Excel

Description automatically generated

This approach will help you in various planning models such as …

  • Workforce planning – when to start calculating benefits 
  • Asset planning – when to begin the depreciation calculations

This can also be used to define start dates by simply adding 1 to the result and determining the first day of the next month. Now we just need a formula to help us when someone obnoxiously tells us to “just perform the task on each day that ends in Y.”

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: Rounded Buttons in Planning Analytics Workspace

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar

Home » Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, TM1

Apex Entertainment Performs Enterprise Planning with Workday Adaptive Planning

February 9, 2023 by Revelwood

Success Stories

How do you move away from spreadsheet-based budgeting, forecasting and reporting for more insight into the operations of the business? With Workday Adaptive Planning.  

Apex Entertainment, headquartered in Marlborough, MA, operates four family entertainment centers in the northeast U.S., including Virginia Beach, Syracuse, Albany and Marlborough. Apex offers attractions that are fun for all ages, with activities such as Indoor Go Karts, Bowling, Laser Tag, Escape Rooms, Ropes Courses, Arcade and Redemption, Sports Simulators, Axe Throwing, Mini Gold, Bumper Cars, Virtual Reality and state-of-the-art event meeting space. Each location offers a full-service dining experience in The Pit Stop Tavern, with a menu that includes 80 gluten-free options as well as vegetarian options. 

“Relying on Microsoft Excel to manage our financial processes handicapped us more than helped us,” said Marcus Kemblowski, COO, Apex Entertainment. “We needed a solution that gave us insight into how to fix problems and would enable us to manage our business in real-time.” 

Apex Entertainment selected Workday Adaptive Planning and Revelwood. The goal of the implementation was to easily see how the business is doing, down to the location and the attraction. Now, with Workday Adaptive Planning, Apex Entertainment has the information available to make strategic decisions. The team can analyze and assess potential expenses regarding forecasted revenue by activity. 

“From the get-go, Revelwood clearly understood our business. They immediately knew what we were discussing and hot to get us to where we needed to go,” added Kemblowski.

Apex Entertainment is not done with its plans for Workday Adaptive Planning. “Workday Adaptive Planning can help us to get where we want to go,” commented Kemblowski. “We now can easily perform top-line to bottom-line budgeting and forecasting. The insights generated by the application are invaluable to the company’s growth.  

Interested in learning the full story? Read the success story to learn how Apex Entertainment benefits from Workday Adaptive Planning.

Read more blog posts on Workday Adaptive Planning:

FP&A Done Right: ESG – An Imperative for Growth

FP&A Done Right: Forecasting Revenue for Services-Based Businesses: A Growth Factor

Home » Planning & Forecasting » Page 5

Filed Under: Success Stories Tagged With: Adaptive Planning, Planning & Forecasting, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Excel TEXTSPLIT

February 7, 2023 by Lee Lazarow

Have you ever needed to parse a text string into different columns in Excel? This is easy to do via the text-to-columns wizard, but what if you wanted to do this via a formula? The TEXTSPLIT function allows you to split a text value across columns. It even lets you split values across rows!  

The function has two required parameters:

=TEXTSPLIT(text,col_delimiter)

  • The text parameter defines the string value you are searching for
  • The column delimiter parameter defines the character(s) used for each split

In addition, there are optional parameters that can be used to determine case sensitivity, determine a row delimiter, and define what to do if two matches in a row are found

The following example shows how to use the function by searching for a space between each word and then putting each word into a new column. The source value is in cell A1 and a single TEXTSPLIT formula has been created in cell A2 (note: the text of the formula has been replicated onto cell A6 to show it in this image).

Graphical user interface, application, table, Excel

Description automatically generated

This next example shows a similar concept but uses a different parameter to instead put each word into a new row.

Table

Description automatically generated

This approach will simplify your searches by eliminating the need to create multiple functions to parse the same set of data.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER

IBM Planning Analytics Tips & Tricks: Excel SEQUENCE

IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process

Home » Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, TM1

IBM Planning Analytics Tips & Tricks: How to Make an MDX Statement Dynamic

January 24, 2023 by Revelwood

Did you know we have a number of resources available to learn more about MDX? We hosted a two-part series on How to Use MDX in Your IBM Planning Analytics Series. We also published a blog post, IBM Planning Analytics Tips & Tricks: MDX Syntax Explained, to accompany part 1 of the webinar series. 

In part 2 of our MDX webinar series, we demonstrate how to make an MDX dynamic by using the power of Excel.

You’ll see we start with a basic Excel report, generated out of IBM Planning Analytics for Excel (PAx). We then take the static, base MDX and turn it into a concatenation of parts of the index statement and the cell reference. In turn, that enables us to change the root account, thereby changing the data that shows in the report.

Watch the full webinar to learn more about working with MDX.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks on MDX:

IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills

IBM Planning Analytics Tips & Tricks: Using MDX to Compare Dimension Hierarchies

IBM Planning Analytics Tips & Tricks: Making Default Cube Views Dynamic with MDX

Home » Planning & Forecasting » Page 5

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

IBM Planning Analytics Tips & Tricks: Approaches in Planning Analytics’ New Set Editor

January 17, 2023 by Revelwood

In Revelwood’s latest IBM Planning Analytics Tips & Tricks video, Lee Lazarow demonstrates three different ways to change a drop-down menu in Planning Analytics’ new set editor.

Watch this video to learn the three approaches:

1. Change the drop-down by doubling clicking the dimension, which opens the set editor

2. Click on the three dots on the right side to open the set editor

3. Click on the drop-down to see the elements currently in the set (note: you need to enable this when you are creating your Exploration)

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Watch more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos

IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel

IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace

Home » Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: IBM Cognos TM1, IBM Planning Analytics, Planning & Forecasting, Planning & Reporting, TM1

IBM Planning Analytics Tips & Tricks: DefineCalc

January 3, 2023 by Revelwood

IBM Planning Analytics for Excel (PAx) version 80 introduced a new function called “DefineCalc.” This function allows a user to create a custom calculation using TM1/Planning Analytics data via the use of MDX.

There are a series of parameters, and the key ones are:

  • sDataSource – The connection URL used when adding your connection to Pax.  You can enter “*”if you would like the calculation to apply to all data sources.
IBM Planning Analytics Tips: DefineCalc
  • sServerName = Your TM1/PA server name.  You can enter “*” if you would like the calculation to apply to all servers.
  • sCalcMUN = The name for the calculation.  This will be referenced in your DBRW formulas.
  • sExpression = The MDX expression being used for the calculation (note: if you would like to remove a custom calculation then set this variable to be blank).

One use case for this function is to grab the total value of a subset. In the example below, we have a report that uses a subset called “DefineCalc Example”:

IBM Planning Analytics Tips & Tricks: DefineCalc
IBM Planning Analytics Tricks: DefineCalc

The following DefineCalc formula was used to create a total:

IBM Planning Analytics Tips & Tricks: DefineCalc

Now, let’s break this apart by each parameter:

  • sDataSource – “*”
    • This will apply to all data sources (if multiple)
  • sServerName = “*”
    • This will apply to all TM1/PA servers (if multiple)
  • sCalcMUN = “[bpmAccount].[Example 1]”
    • This first half of this value defines the bpmAccount dimension
    • The second half of this value consists of a unique name within the bpmAccount dimension
  • sExpression = “AGGREGATE(TM1SubsetToSet([bpmAccount],’DefineCalc Example’))”
    • This is an MDX expression that will give the total of the “DefineCalc Example” subset within the bpmAccount dimension

The result of this formula is populated in the cell as “Example 1.”

IBM Planning Analytics Tips & Tricks: DefineCalc

We can now reference “Example 1” within the DBRW formula as an element in the bpmAccount dimension.

IBM Planning Analytics Tips & Tricks: DefineCalc

The =Sum formula of the three data rows matches the DBRW that references the DefineCalc function.

IBM Planning Analytics Tips & Tricks: DefineCalc

This shows one common use case for the new DefineCalc function, but the use MDX allows for countless other applications!

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: MDX Syntax Explained

IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based on a Cube

IBM Planning Analytics Tips & Tricks: TM1Ellist

Home » Planning & Forecasting » Page 5

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

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Interim pages omitted …
  • Page 19
  • 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.