• 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

IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER

December 13, 2022 by Lee Lazarow

A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing, Microsoft has introduced two additional functions that can help you search for specific text values. These functions are TEXTBEFORE and TEXTAFTER.

  • TEXTBEFORE will return text before the characters you are searching for
  • TEXTAFTER will return text after the characters you are searching for

Both functions have two required parameters:

=TEXTBEFORE(text,delimiter)

=TEXTAFTER(text,delimiter)

  • The text parameter defines the string value you are searching for
  • The delimiter parameter defines the point after you want to extract

In addition, there are optional parameters that can be used to determine case sensitivity and what to do if no match if found.

The following example shows how to use these functions:

Graphical user interface, text, application, chat or text message

Description automatically generated

This approach will simplify your searches by eliminating the need to merge functions such as FIND, and LEN and LEFT/RIGHT together.

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: How to Set Up Action Buttons in Planning Analytics for Excel

IBM Planning Analytics Tips & Tricks: Excel SEQUENCE

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

Home » Planning & Reporting » Page 3

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

FP&A Done Right: Approaches to Long-Term Planning

November 14, 2022 by Lee Lazarow

“If you fail to plan, you are planning to fail.” – Ben Franklin

In our collective rush to react to ever-changing marketplace dynamics and shifts in the economy, it’s easy to focus on short-term plans, to the neglect of long-term planning. Today’s leaders need to have several plans – short-term, medium-term, and long-term.

Different plans for different needs

How do these plans differ? A short-term plan is designed to show granular details for a limited time frame. This is often updated monthly, although we have some clients updating their plans on a weekly basis. One of our clients follows a process where local managers update their plans on Mondays and Tuesdays, have the regional managers review the data on Thursdays, and allow senior management to analyze and assess the data on Fridays. Each Monday they start the process over.

Most organizations utilize a medium-term plan that looks out anywhere from a few quarters to a full year. Most people will think of this as a standard monthly forecast with data at a bit more of a higher level, but still somewhat details.

A long-term plan often goes out multiple years. Many companies create a 5-year plan, although some industries such as entertainment and pharmaceutical often create 20-25 year plans. A long-term plan is a high-level view of the business. It’s not nearly as granular as short, or even medium-term plans. The plan does not get down to the level of looking at a GL account or a customer. It’s a measuring tool and a defined way of reviewing the progress of the company. In short, long-term planning helps to set the company’s direction.

The essentials of long-term planning

The long-term plan gives you guidance on how to answer several questions, including:

  • How can we expand the company?
  • How can we look into acquisitions?
  • What products, geographies, and verticals can we or should we add?
  • What products no longer make sense?
  • How do debt payments impact cash flow?
  • What type of labor, buildings, locations, and equipment do we need?

A long-term plan can be considered a proactive approach to risk mitigation, enabling companies to plan, think ahead, prepare for, and lessen the impact of potential negative effects. At Revelwood, we recommend two approaches to long-term planning: the growth percent approach and a driver-based approach.

We often see both of these methods used when performing long-term planning in IBM Planning Analytics with Watson:

Growth percent approach

The growth percent approach allows you to adjust groups of data (accounts, departments, etc.) by increasing or decreasing the values from the previous year. Some clients prefer to simply use a single percentage (example: reduce all expenses by 2% each year for the next five years) whereas some clients prefer to include more variation (example: reduce utilities expenses by 2% next year, by 3% the following year, and by 4% for the next three years). But no matter what level of detail is used, Planning Analytics’ powerful scripting tool will perform the entire long term plan in a matter of seconds.

Driver-based approach

A driver-based approach uses operational activity to calculate key variable revenues and expenses. This approach allows you to simplify the input by defining a set of drivers and creating calculations that use the drivers.  For example, a single driver of “units sold” can be used to immediately calculate revenue, COGS, and some of your variable expenses using the tool’s efficient calculation engine.

Mitigate risk with long-term planning

Long-term planning is your company’s assurance against planning to fail. There’s a reason why Franklin’s quote has lasted through the years. And it should be the motto of every planning team.

Learn more about long-term planning by watching our on-demand webinar – Long-Term Planning in IBM Planning Analytics.

This post originally appeared on IBM’s Journey to AI blog.

Home » Planning & Reporting » Page 3

Filed Under: FP&A Done Right Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, IBM Planning Analytics, Planning & Reporting, TM1

IBM Planning Analytics Tips & Tricks: MDX Syntax Explained

October 18, 2022 by Lee Lazarow

MDX enables you to query dimensions and cubes, lists of elements, data points, calculations, and more. 

The first step in learning MDX is to understand the syntax. Below is an example of an MDX expression that returns all elements of the product dimension sorted in ascending order. To understand the expression, we’ve color-coded the syntax below. 

Part1, the part that is associated with the TM1 structure and model, is in green. This defines cubes, dimensions, hierarchies, elements and more. 

Part 2, in blue, is the MDX Function.

Part 3 is in red. These are known as curly brackets or braces. These convert the results of the MDX Expression into a set. 

The Expression below lets you list all elements of the product dimension and sort the list in ascending order:

Graphical user interface, text, application, email

Description automatically generated

Revelwood recently hosted a webinar on How to Use MDX in your IBM Planning Analytics Environment. Watch the recording to learn more about using MDX.

Interested in learning more about MDX? We have another MDX-specific webinar on Wednesday, November 9, 2022 at 1pm ET. Attendees will learn advanced MDX functions and see real-life examples of how Revelwood used MDX to address complex reporting requirements and to solve client challenges. 

Have a question about MDX? Register for our upcoming webinar or reach out to us at info@revelwood.com

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: Making Default Cube Views Dynamic with MDX

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

Home » Planning & Reporting » Page 3

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

IBM Planning Analytics with Watson Named Value Index Leader by Ventana Research

October 7, 2022 by Revelwood

News & Events

Ventana Research has named IBM Planning Analytics with Watson a Value Index Leader in the firm’s Business Planning Value Index: 2022 Vendor and Product Assessment. The firm evaluated IBM Planning Analytics with Watson, along with planning products from Anaplan, Board International, Infor, insightsoftware, OneStream Software, Oracle, Planful (formerly Host Analytics), Prophix, SAP, Unit4, Vena Solutions, Wolters Kluwer and Workday.

IBM was categorized as an Exemplary Vendor, ranking first overall in the Value Index. Additional rankings by IBM Planning Analytics include:

  • Ranking second in Product Experience
  • Ranking Second in Customer Experience
  • Named as a Value Index Leader in TCO/ROI
Table

Description automatically generated

The purpose of the report is to “evaluate the maturity of software vendors and products and their value for enterprise use in business planning.” It is designed to provide a “balanced perspective of vendors and products that is rooted in an understanding of business drivers and needs.” Ventana uses research-based analytics and methodology to generate the Value Index ratings. The firm then “builds to a set of indicators it presents in both analytic and graphic form, each depicting the value of a specific vendor’s offering in terms of what it can deliver relevant to business planning needs.”

According to Ventana, “Technology is essential to making planning and budgeting more strategic, more strategic, more productive and more consequential to an organization’s success.”

Download your complimentary report!

Home » Planning & Reporting » Page 3

Filed Under: News & Events Tagged With: Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, Planning & Reporting, TM1

Modern Accounting: The Impact of Investing in Accounts Receivable

September 29, 2022 by Revelwood

This is a guest blog post from our partner BlackLine, explaining how to gain confidence cash flow.

Historically, accounts receivable (AR) has been the victim of a lack of investment from a technological perspective. Primarily, this lack of investment in AR is the result of something simple: a misunderstanding.

AR is largely regarded as a necessary but transactional back-office function and not something that creates a “value-add” for the business. Unlike the core accounting of bookkeeping, AR’s reputation is that of a kind of conveyor belt. Necessary, but low impact in the grand scheme of things. As a result, AR is the victim of fundamental misunderstandings regarding how it can be optimized—and the business impact that the right optimization can have.

When finance professionals think about how to streamline or optimize AR, typically it has been viewed as something that may be better offshored or that the ERP already handles. This is due to it being largely manual, time-consuming, and often transactional. But this simply moves the problem elsewhere, rather than solving the underlying issue.

Investing in technology that automates the accounts receivable function grants you complete visibility over the flow of cash into your business, in real-time. The data, intelligence, and real-time oversight of working capital that optimized AR offers to businesses are invaluable, for several key reasons.

Unlocking Working Capital

Applying customer payments to customer accounts quickly and accurately is the cornerstone of successful AR. However, manual processes lead to significant delays in unlocking crucial cash flow.

Money owed by customers is one of the largest assets on any balance sheet. A recent report by PwC estimated that the amount of working capital held hostage in this way is an enormous €1.2 trillion globally. According to PwC, releasing this cash would be enough for global companies to boost their capital investment by 55%, without the need to look externally for funding or put their cash flow under unnecessary pressure. With interest rates as they are right now, never mind what might be on the horizon, looking internally to find opportunities to streamline cash flow and payment processes is a no-brainer.

Let me give you an example: on average, organizations are paid on day 50-55. For a business with $500m revenue, each day is worth $2m. By automating and optimizing payment processes, businesses can potentially release a significant amount of cash into the bottom line that can then be put to work in the business.

Releasing cash from receivables is the quickest and cheapest way to more working capital, yet organizations continue to rely on manual processes which don’t provide proper visibility and tie up cash for far longer than necessary. Investing in AR frees up more working capital, which means stronger business resilience and enables more effective decision-making. Put simply, it puts much more power in your hands and leaves much less up to guesswork.

Maintaining Lasting Customer Relationships

Credit controllers used to be a lot more persistent. This was clear in the terminology they used. They looked at customers as “debtors.” This sounds more akin to something you’d read in a Dickens novel than the way a business refers to its trusted partners.

The way you treat your customers not only reflects your efficiency internally but crucially shapes perceptions, both for potential new customers and those who might be on the fence about jumping ship. Chasing a customer for a payment that was made days before, simply because you’re reliant on manual processes that don’t give you proper visibility, could reflect poorly on your organization. Aside from the wasted time and effort, receiving an erroneous demand for payment on a bad day could be the difference between a continued relationship and a swift parting of ways.

Customers provide the value for our organizations. It’s our customers that are going to support us through the tough times. A mindset shift is required here at all levels of business, including the C-suite. Customers should be treated with the same respect when they owe money as when they don’t. Investing in AR creates the visibility over customer payment behaviors that is essential to this.

The right solution can unlock decision intelligence by removing time-consuming and error-prone processes involved in preparing, transforming, and visualizing data. This lets your teams make more informed decisions around credit risk policies, collection strategies, or credit limit increases to create greater value for the business. It can help you gain visibility into customer behavior changes. This could unlock opportunities for you to work with customers to solve payment challenges before they become a major problem, or increase their line of credit and in turn, your revenue. This can improve profitability by reducing the financial risks posed by write-offs and late payments.

Creating greater visibility over real-time payments allows you to leave the war of attrition over unpaid invoices behind. This leads to a more customer-centric approach to credit, collections, and complaints that can help you to maintain good customer relationships.

Retaining Talent for a Competitive Advantage

In an increasingly competitive business environment, the ability to attract and retain top talent is crucial to business success. A recent survey commissioned by BlackLine suggests that one of the first steps finance and accounting needs to take to retain their best workers is to eliminate transactional, mundane work. More than a quarter (28%) of FP&A professionals surveyed said there weren’t opportunities to learn new skills because transactional work takes up so much time, while a similar number (26%) claimed that they had become bored of the mundane, repetitive nature of their jobs. What’s more, a quarter (26%) also claimed not to have time to focus on future career development.

It’s clear that your talent wants to spend their time adding value, regardless of function. Completing a long list of manual tasks, which could be automated, is not adding value. If 80% of your time is spent on routine tasks that can be automated, that’s 80% of your value gone before any major or strategic tasks arise. This wasted energy wastes your employees, which passes on up the chain. 

Automation frees up F&A team members to focus on strategic, more career-focused goals, ensuring their motivation and energy is spent bringing value to your business (and not someone else’s).

Don’t Let Manual Processes Decide Your Fate

Many organizations have now automated processes such as accounts payable, but the prevalence of manual processes in accounts receivable continues to pose serious health issues for businesses. The problem is that automating some processes and not others could ultimately cost you more than you bargained for. If the budget only stretches so far, it’s essential to upgrade the process that will have the biggest impact. Let me explain by way of an analogy.

Imagine you need to dig a hole somewhere in your back garden. You could do it with a shovel, but it needs to be a very large hole, so doing it that way would take a huge amount of time and exhausting effort. So, you hire a contractor with the right equipment. This gets the job done much faster and with much less effort. The problem is, you didn’t know where exactly to dig the hole to begin with and you’ve dug it in the wrong place. Now, not only do you still need to dig the hole, but you need to repair the large area of back garden that is now a building site.

Automating some FP&A processes but leaving AR up to manual processes creates a similarly traumatic scenario. Choosing to invest in accounts receivable opens up a treasure trove of intelligence and profitability that could make the difference between success or failure. When it comes to accounts receivable, investment is no longer a nice-to-have, it is now a must-have for survival.

Read more about Modern Accounting:

Modern Accounting: Driving Sustainability

Modern Accounting: Why Does Intercompany Accounting Crash Your Close?

Modern Accounting: Four Key Ways AR Automations Propel Financial Operations

This blog post was originally published on the BlackLine blog.

https://www.blackline.com/blog/investing-in-ar-essential-for-survival

Home » Planning & Reporting » Page 3

Filed Under: Financial Close & Consolidation Tagged With: accounting, accounting automation, BlackLine, Financial Performance Management, Planning & Forecasting, Planning & Reporting

The Total Economic Impact of IBM Planning Analytics / TM1

September 23, 2022 by Revelwood

News and events

Are you evaluating IBM Planning Analytics / TM1 for integrated financial and operational planning? Then Forrester’s report on the Total Economic Impact of IBM Planning Analytics is a must-read. The report details the cost savings and business benefits of the technology. It “examines the potential ROI enterprises may realize by deploying Planning Analytics.” It also provides a framework to evaluate the potential financial impact of Planning Analytics. 

Forrester interviewed several Planning Analytics clients. Prior to deploying Planning Analytics, these organizations “lacked data cultures that would allow them to make the nest decisions using accurate, real-time data.” 

After deploying Planning Analytics, the organizations “were able to unify their disparate planning systems,” gaining many other benefits, including:

  • Increasing staffing efficiencies by 10%
  • Reducing budgeting effort by 63%
  • Speeding up data processing by 80%
  • Reducing forecasting effort by 70%

For example, one organization reduced the average time to run a planning system refresh from 45 minutes with their legacy system to less than 10 minutes with Planning Analytics. Forrester concluded this time savings alone “leads to efficiencies valued at a three-year present value (PV) of more than $1 million. 

Another organization also found time savings in their forecasting activities. “With a thousand different classes and roll-ups, business analysts were probably spending 40 hours a month preparing P&Ls. We’ve dropped that down to 2 to 3 hours of time,” said a director of FP&A for a retail company.

A picture containing timeline

Description automatically generated

Learn more about the efficiencies gained with Planning Analytics. Download the Forrester TEI report today.

Home » Planning & Reporting » Page 3

Filed Under: News & Events Tagged With: Financial Performance Management, IBM Planning Analytics, Planning & Reporting

IBM Planning Analytics Tips & Tricks: 21/21/21

September 20, 2022 by Lee Lazarow

Some of you may remember an Excel feature that we wrote about a while back, which explained how the DATE function will convert invalid dates into real ones.  For example, DATE(2020,7,35) will be converted to August 4, 2020, since there are not 35 days in July.

Here is where the fun begins!

  • This week includes the 21st day of the month of September
  • September is the 9th month of this year, which is also the 21st month of last year
  • Last year was 2021

Put this all together and we have another special event happening this week …

On September 21, 2022,

the resulting date will be 21/21/21

Graphical user interface, application

Description automatically generated

And if we take it a step further …

At 9:21p and 21 seconds on 9/21/2022, 

the resulting time will be 21:21:21 on 21/21/21

This is why we love Excel!

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: Creating Control Objects from the Modeling Workbench

IBM Planning Analytics Tips & Tricks: Garbage Memory

IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models

Home » Planning & Reporting » Page 3

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

Workday Adaptive Planning Tips & Tricks: Creating an Excel File Data Source

September 14, 2022 by Dave Miersch

Did you know you can create an Excel file spreadsheet data source for Workday Adaptive Planning?

Watch Dave Miersch, Revelwood’s Practice Leader for Workday Adaptive Planning, demonstrate how to create and use an Excel file as a data source for Adaptive Planning. Dave shows you how to:

  • Use any data source, such as from an ERP system or data warehouse
  • Create a new data source
  • Find and select the spreadsheet option
  • Name the data source
  • Import the spreadsheet

Adaptive Planning makes it very easy to import and export an Excel spreadsheet!

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Data Integration and the Planning Data Source

Workday Adaptive Planning Tips & Tricks: Utilizing Split Rows in Modeled Sheets

Workday Adaptive Planning Tips & Tricks: Data Integration and the Excel Spreadsheet Data Source

Home » Planning & Reporting » Page 3

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Planning, Financial Performance Management, Planning & Reporting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

IBM Planning Analytics Tips & Tricks: Beginning to Explore the Set Editor in Planning Analytics for Excel

September 13, 2022 by Marc Assenza

The IBM Planning Analytics Set Editor is the equivalent to the TM1 Subset Editor for Architect and Perspectives, but with expanded functionality.  Getting started with the set editor is as simple as double clicking on a dimension within your exploration.

Graphical user interface, application, Teams

Description automatically generated

In this example, I double clicked on the Company dimension.  Right away you can see that it is organized via a left and right pane where the left side represents what is available within the dimension and the right side shows what is currently selected, or the current set. 

Graphical user interface, application

Description automatically generated

The left side now contains two drop downs: one for hierarchies and one for members.  The members selection allows you to choose a series of pre-built categories along with existing subsets.

Graphical user interface, application

Description automatically generated
Graphical user interface, text, application, email

Description automatically generated

After selecting the members to be inserted into the current set, you can place them into the right side’s Current Set by simply clicking on the Insert button between the panes.  Click the “Apply and close” button your newly selected member(s) will show within your exploration.

Graphical user interface, application, Word

Description automatically generated

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models

IBM Planning Analytics Tips & Tricks: Customizing Background Colors for Data and Header Cells

IBM Planning Analytics Tips & Tricks: Adding and Editing Connection URLs in Planning Analytics for Excel

Home » Planning & Reporting » Page 3

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

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