us-analytics.png
Ask an Expert

3 Money-Saving Steps for Any Planning or PBCS Implementation

Whether it’s an on-premises Hyperion Planning application or Oracle PBCS cloud application, implementing a sophisticated planning, budgeting, and forecasting solution can be exciting and sometimes daunting. How do you start preparing?

Know Your Process

No one likes surprises or derailments in a project — it causes headaches and extra cost. One key way to hit the ground running is to know your process before an implementation begins. This will help you and your team clearly identify pain points and articulate mechanisms that dictate future driver-based modeling with your new technology.

Pro tip: Use the EPM Strategy Checklist to get a full picture of your people, processes, and systems.

Provide Documentation

Not only is it important to articulate, but it is essential to have your process well-documented. Write documentation on the systems you build and detail what they calculate, in which way, and why. A process document describing these flows and formulas, along with a high-level view, will keep information flowing freely.

In this context, we often walk into an implementation and encounter massive Excel files with multiple tabs, lack of standardized naming conventions, a hodgepodge of accounts without unique identifiers, and so on. It takes a lot of time and consulting dollars to sort through. As tedious as it sounds, getting organized with color coding, table structures, and naming conventions will serve your organization in the long run.

For instance, color coding your spreadsheets makes it easy to identify at a glance what is a formula versus a constant versus a link. If you look at the first example below, there is no differentiation between an input and a formula. However, on the second sheet, you can quickly see that there are lots of formulas and much fewer inputs — this allows a developer to know what is happening on a sheet easily, saving time and money.

Spreadsheet without documentation:

not_documented_spreadsheet_PBCS.png

Updated spreadsheet:

well_documented_spreadsheet_PBCS.png

This helpful color-coding strategy can also be applied to the following:

  • Tabs that are pulling from another sheet
  • Links from one workbook to another workbook or to another tab
  • Conditional formatting based on number value, text, dates

Anticipate Tasks & Timeline

One of the best ways to prepare for a PBCS implementation is to see how others have successfully done it.

Pro tips: 


Regardless of your implementation, these simple tips will benefit your organization by bringing more clarity, transparency, and availability. No one person should hold the key to decoding the plan.
Download the PBCS Project Planning Toolkit

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk