• 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

FP&A Done Right: Beware of Budgeting – Part II

August 9, 2019 by Brian Combs Leave a Comment

FP&A Done Right

How is your budget/budget prep coming along? Have you set aside time to rethink your process? In that last installment of FP&A Done Right, we started our enumeration of the problems with traditional budgeting. Before I discuss several more, here is a reminder of the last few problems:

  • Time consuming and costly
  • Quickly irrelevant and outdated
  • Financial process largely disconnected from specific drivers

Let me highlight more now and then we will move towards some alternative approaches.

Principled upon negotiating/gamesmanship

I can still remember my first visit to Corporate to review (or as I soon learned, to defend) our annual budget. Back then, I was fresh off my MBA and I had landed a job at one of our Region offices. We had just spent months building a plan from the lowest level, capturing input and feedback from every location manager and painstakingly describing every variance to the penny. We were ready. This was a done deal. Boy was I naïve. We were escorted into a nice room with a large table. Around the table I could see the president of our division and the heads of every major functional area ready to discuss our plan. Game on! My controller and I didn’t even get a chance to pull out most of the backup schedules we had created. He spent his time trying to negotiate fewer expense reductions and less revenue while I was busy taking notes on all the “savings” and “initiatives” the team had just found for us during the review. Great news. Thanks for the assist. I learned my lesson that day. After that, I knew that I had to pad my expenses and sandbag my revenue. They knew we did it too which is why they had us take a 5-10% cut in expenses as soon as we walked in the door. That is a difficult game to stop playing and, in the end, no one wins. Yet, many of us continue to play.

Triggers Unnecessary Spending

Since our budget numbers are frequently tied to prior year spend rather than being based on needs (a zero-based budgeting approach), we feel the need to spend money just so we have the same amount available to us next year. This is crazy, but I still see it today. We should be creating an environment where our front-line managers are rewarded for being fiscally conservative, not penalized. If you find a way to save money this year, we should be analyzing what you did so we can replicate it with your peers rather than giving you a hard time next year since you now have a large YoY increase.

Creates an inflexible performance contract

This is a big one as it impacts your managers directly in their bank accounts. This is especially true when incentives are tied to performance against the annual business plan. Once my budget was completed, I knew I would spend the rest of the year running actuals vs budget reports so we could determine what our bonus would be. If you remember from the first part of this blog, almost two-thirds of budgets are outdated between 4-6 months into the plan. If that’s the case, why are we using that number to determine the bonus for our managers? I want to reward my managers for changing course if they see something that is in the way of them achieving their goals. Compensate them based on what is occurring now, not what you thought was going to happen 12 months ago. When we focus on an inflexible budget number, we begin to manage to that number.  Don’t fall in to that trap.

Drives Wrong Behavior

It doesn’t take long before you know roughly where the year will pan out vs the budget. You know fairly quickly whether it is attainable or a long shot.  Since compensation is tied to the budget, it tends to drive the wrong behavior. You should expect your managers to do what is in their best interest. It is your job to ensure that by doing so, the company gains as well. If I am in the back half of the year and I already know I can’t achieve my annual budget numbers, where is the incentive for me to continue to find cost savings and improve my processes. I might as well give up on trying to get better this year because I won’t reach my bonus threshold anyway.  Right? Maybe I’ll push off a cost savings initiative until next year.  Or I’ll try that new revenue generating idea at the start of next year. The same is true if you have already maxed your bonus for the year. Why continue to do better? Save some of that goodness for next year. You need to make sure that the company goals are aligned with the individual goals. A budget can create a false sense of security and it may be holding the organization back from achieving its true potential.

It’s often easier to ‘see’ a problem when someone else describes it. My hope is that while reading this, you took some time to compare and contrast these issues with your methodology and approach to the budget. Does anything look familiar to you? If so, perhaps it is time to make a change.  Please reach out and share your stories with me. In my next blog, we’ll discuss some alternatives to these problems that you can begin using immediately.  Happy budgeting!

Read more posts in Brian’s FP&A Done Right Series:

FP&A Done Right: Beware of Budgeting, Part I

FP&A Done Right: The Importance of Including FP&A Often and Early in Your Strategic Planning Process

FP&A Done Right: 5 Signs it’s Time to Rethink Your Process

Home » Planning & Reporting » Page 11

Filed Under: FP&A Done Right Tagged With: Analytics, Beyond Budgeting, Budgeting, Budgeting Planning & Forecasting, Financial Performance Management, FP&A, FP&A done right, Planning & Forecasting, Planning & Reporting

IBM Planning Analytics Tips & Tricks: Financial Rules

August 6, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know one of the great things about Excel is that there are many built-in functions that calculate values associated with specific industries? One of these industries is the financial industry where Excel is sometimes used to calculate values associated with annuities. But did you know that some of these formulas are also built into Planning Analytics for use within rules?

Here are three annuity formulas that can be used in Planning Analytics rules:

The FV formula returns the value of an annuity at the time of the last payment.

           FV(payment, interest, periods)

Payment = The amount of the payment made per period.

Interest = The interest rate paid per period.

Periods = The number of periods in the annuity.

The PV formula returns the initial or principal value of an annuity.

           PV(payment, interest, periods)

Payment = The amount of the payment made.         

Interest = The interest rate paid per period.

Periods = The number of periods in the annuity.

The PAYMT formula returns the payment amount of an annuity based on a given initial value or principal, an interest rate, and a number of periods.

            PAYMT(principal, interest, periods)

Principal = The present value (total amount) that a series of future payments is worth now.

Interest = The interest rate paid per period.

Periods = The number of periods in the annuity.

All of these formulas assume that payments are made at equal intervals of time (when applicable) and that they are made at the end of each period. 

Excel has a lot of great built in functions, so why can’t Planning Analytics?  Well, as you can see … it does!

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

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

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

 

Home » Planning & Reporting » Page 11

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

IBM Planning Analytics Tips & Tricks: IFERROR

July 30, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know one of the great things about creating TM1 Web sheets is that you simply need to create an Excel sheet and then press a button called Publish? This will convert your Planning Analytics formulas into a web-based interface that your users can easily access.

In addition to the Planning Analytics formulas, IBM is continuing to expand the use of Excel’s native formulas.  Planning Analytics version 2.0.7 introduced the use of the IFERROR formula into TM1 Web sheets.

The IFERROR formula determines if an error exists and then returns an alternative value, such as a text message, in place of the error message.  The error checks include any of the following results: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

=IFERROR (value, value_if_error)

Here is an example of the IFERROR formula within a spreadsheet:

=IFERROR ( A1/B1, “There is an error in the calculation”)

The result of this formula will eliminate hard-to-read results such as #N/A or other results that could make your Web sheet less user friendly.

IBM continues to expand the Excel formulas that can be used in TM1 Web and Revelwood will continue to keep you updated with these additions.

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

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

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Planning & Reporting » Page 11

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

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

July 23, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know that rules are used in TM1 to perform live calculations without the need for any manual intervention or on-demand scripts? This is a very powerful aspect of Planning Analytics and, when used properly, increase the value of the tool for your users.

There are some aspects of rules that I often see people forgetting. Here are some friendly reminders about how to use these components properly:

Division

TM1 offers two different approaches to write a division formula via the “slash”. Not only do I often forget the difference between the two slashes, but I also sometimes forget the names of each slash.

/

The forward slash; goes bottom left to top right

Division by zero using this operator returns an undefined value

\

The back slash; goes top left to bottom right

Division by zero using this operator returns zero

Mathematical Comparisons

TM1 allows for mathematical comparison of numbers using standard nomenclature such as =, >, < and <>. However, TM1 also offers the ability to compare strings via the same functionality. You can compare strings by simply adding an @ symbol to the nomenclature.

Numeric check:  IF ( numValue = numCounter )

String check: IF ( strValue @= strCounter )

And, Or, Not

When writing comparisons, we often use the AND concept and the OR concept.  AND is written by using the ampersand symbol ( & ) and OR is written by using the percent symbol ( % ). But did you know that you can also write NOT by using the tilde ( ~ ).

~( x = 5 ) is the same as writing ( x <> 5 )

Rules are a very powerful component of Planning Analytics. Hopefully these components help you continue creating efficient code.

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

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

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Planning & Reporting » Page 11

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

Learn how to Create Reports in Adaptive Insights

July 17, 2019 by Lisa Minneci Leave a Comment

Tips & Tricks

HTML reports are the “bread and butter” of the finance professional. We’ve created a short demo video of how to easily create reports in Adaptive Insights.

In this video, part of our series The Capabilities of Adaptive Insights, Ken DiSessa shows you how to create a variance report looking at a budget versus actuals. He discusses the color coding and icons in Adaptive Insights, how to drill down into details, and the powerful explore cell feature.

Watch Reporting in Adaptive Insights and you’ll learn how to create a new report using filters and parameters.

Did you miss the first video in our series?

Check out Dashboarding in Adaptive Insights.

Learn more about Revelwood and Adaptive Insights:

Revelwood Named Adaptive Insights Partner Rising Star of the Year

Revelwood’s Insights on Adaptive Live 2019

Adaptive Insights Earned Gartner Peer Insights Customer Choice Award for Best Cloud Financial Planning and Analysis Solutions of 2019

Home » Planning & Reporting » Page 11

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

IBM Planning Analytics Tips & Tricks: How to Manipulate Case Used for Text

July 16, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know IBM Planning Analytics rules can be used to manipulate the case used for text?  There are rules to change values into both uppercase and lowercase.

UPPER

Converts an entire string to upper case

UPPER(‘Lee Lazarow wrote this’) becomes LEE LAZAROW WROTE THIS

LOWER

Converts entire string to lower case

LOWER(‘Lee Lazarow wrote this’) becomes lee lazarow wrote this

CAPIT

Converts the first letter of each work to upper case

CAPIT(‘Lee Lazarow wrote this’) becomes Lee Lazarow Wrote This

But what if you only want to capitalize the very first character?  You can do this by using these commands in conjunction with the LONG and the SUBST formulas. 

Here is an example of a set of rules that show various ways to manipulate a text string.

IBM Planning Analytics Tips & Tricks: Rules for Capitalization

By combining formulas together in Planning Analytics, text can easily be manipulated in a variety of ways.

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Ways to Stop a TI Process

IBM Planning Analytics Tips & Tricks: Ways to Skip a Record Using a TI Process

IBM Planning Analytics Tips & Tricks: How to Maintain a Hierarchy via a TurboIntegrator Process

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Planning & Reporting » Page 11

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

Revelwood Launches “The Capabilities of Adaptive Insights” Video Demo Series

July 11, 2019 by Lisa Minneci Leave a Comment

Video

We’ve exciting news for those who follow our award-winning Adaptive Insights practice. This week we’re launching a new four-part YouTube series, The Capabilities of Adaptive Insights.

In these short videos Revelwood’s Ken DiSessa walks you through how quickly and easily you can do specific activities and tasks in Adaptive Insights cloud-based business planning software. The first video, Dashboarding in Adaptive Insights features Ken demonstrating how easy it is to use Adaptive Insight’s dashboard capability. He’ll show you how to build some of the 13 different types of charts, including KPI charts, bar charts, pie charts and more.

You’ll also be able to see how some things that are extremely difficult and hard in Excel are easy in Adaptive – specifically, waterfall charts.

Subscribe to Revelwood’s YouTube channel to watch all the videos in our series on The Capabilities of Adaptive Insights.  

Learn more about Revelwood and Adaptive Insights:

Revelwood Named Adaptive Insights Partner Rising Star of the Year

Revelwood’s Insights on Adaptive Live 2019

Adaptive Insights Earned Gartner Peer Insights Customer Choice Award for Best Cloud Financial Planning and Analysis Solutions of 2019

Home » Planning & Reporting » Page 11

Filed Under: Videos, Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, Planning & Reporting

IBM Planning Analytics Tips & Tricks: Ways to Stop a TI Process

July 9, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know there are two different ways to stop a TurboIntegrator script?

The ProcessBreak command stops processing source data and proceeds directly to the Epilog.  This approach allows you still run code in the Epilog that can perform tasks such as deleting subsets, writing to a process tracking cube, or running other processes.

Here is an example of skipping the data and metadata section if a parameter called pVersion does not exist:

            IF ( DIMIX ( ‘Version’, pVersion) = 0 );
                 PROCESSBREAK;
            ENDIF;

As you can see, there are no parameters to this command.  You use this by simply telling Planning Analytics to go to the Epilog.

If, however, you want to completely end the process then you can use the ProcessQuit command.  This command completely terminates the process without running anything in the Epilog.  Here is an example of doing the same check with ProcessQuit.

            IF ( DIMIX ( ‘Version’, pVersion) = 0 );
                 PROCESSQUIT;
            ENDIF;

It’s up to you to determine how you want to stop a TI script from processing.

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Ways to Skip a Record Using a TI Process

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

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

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

Home » Planning & Reporting » Page 11

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

IBM Planning Analytics Tips & Tricks: Ways to Skip a Record Using a TI Process

July 2, 2019 by Lee Lazarow Leave a Comment

Tips & Tricks

Did you know there are two different ways to skip specific records when you are running TurboIntegrator scripts?

ItemSkip is used to skip a specific record. This is often nested within an IF statement and used when you want to simply ignore a record. Here is an example of skipping a record if a variable called vValue is negative:

            IF ( vValue < 0 );
                 ITEMSKIP;
            ENDIF;

As you can see, there are no parameters to this command. You use this by simply telling Planning Analytics to skip the record.

If, however, you want to skip the record and create a record in the error log then you can use the ItemReject command. This command allows you to customize the message that appears in the log. Here is an example of rejecting the same record using ItemReject.

            IF ( vValue < 0 );
                 ITEMREJECT (‘The value is less than zero.’);
            ENDIF;

It’s up to you to determine how you want to skip records.

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!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace

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

IBM Planning Analytics Tips & Tricks: Synchronizing Selectors in Planning Analytics Workspace

Home » Planning & Reporting » Page 11

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

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