• Product
        • Planning Maestro
          • Product Overview
          • Watch Demo
          • Schedule a Live Demo
          • Plans
          • Service & Support
        • Capabilities
          • Consolidation
          • Budgeting
          • Forecasting
          • Scenario Planning
          • Performance Dashboards
          • Financial Reporting
  • Solutions
        • Industries
          • Nonprofit
          • Healthcare & Life Sciences
          • Finance & Insurance
          • Manufacturing & Distribution
          • Retail & Hospitality
          • Software & Technology
          • Other Industries
        • Integrations
          • QuickBooks Online
          • Microsoft Dynamics 365
          • Sage Intacct
          • NetSuite
          • Abila
          • Other Integrations
  • Resources
        • All Resources
          • Our Blog
          • Webinars
          • Whitepapers & E-Books
          • Videos
          • Customer Case Studies
  • Company
        • About Us
        • Leadership Team
        • Partners
        • Press & News
        • Awards
        • Careers
  • Contact
  • Search
  • Menu Menu
Help Hub
Search
Watch Demo Request A Quote

Our Blog

Budgeting Life Hacks: OLAP Cubes Make Budgeting Easier

February 1, 2017/ OLAP cube/By Jason Lin, CFO

Who doesn’t want to make their lives easier? I think that’s why life hacks are so popular. Budgeting is critical for staying in alignment with our strategic objectives but that doesn’t mean that there aren’t ways to make it easier and better.

Don’t worry about whether you’re using a modern budgeting solution or if you haven’t migrated to one yet from Excel, either way, the elements of an OLAP cube (online analytical processes) are a great way of assessing whether you’ve considered everything you’ve needed to or if you’ve got a bit more work to do. When you go through them, you’ll be well on your way to producing a budget that contains a full scope of variables and assumptions that will serve you well.

Creating and utilizing a perpetual budget using cube structures as your guide gives you a solid base for your overall budget as well as for revisiting when you’ve got what-if scenarios to run. Here’s a link to an article I wrote for the annual Financial Executives International magazine that explains it in a lot more detail if you’d like to check it out.

Ban the Vacuum

Get comfortable with the fact that your budget won’t be created or used in a vacuum. Reality will come at it from every direction. Consider your data – all the facts, assumptions, timing, risks, and alternatives – as part of your data warehouse.

Your KPIs, their dependencies and variables are on sliding tracks, just like the adjustment filters on an equalizer. You’re able to move the elements separately of or in conjunction with one another. Nothing happens in isolation and there’s always a consequence to any movement.

Cube Structures

Each of these cube elements need to be considered as you preparing your annual budget, make adjustments or create what-if scenarios.

  • Fact Tables – processes or events
  • Dimension Tables – the who or when
  • Dimensions – used independently, multiple times within a table, or in multiple tables
  • Attributes – characteristics that describe something
  • Schemas – where attributes intersect between tables
  • Relationships – hierarchies and exceptions
  • Measures – the numbers (i.e. quantities, prices, and sales). They associate the dimensions with one another.
  • KPIs – leading indicators move the needle, lagging indicators record the outcomes
  • The cube – the output that you use for evaluation; such as balance sheet, P&L, and cash flow reports

Scenario Planning

Most financial professional can easily accept that things are going to happen. Life rarely plays out exactly as we’ve planned. Options are all around us. Choices need to be made.

Extend the OLAP cube concept to your scenario planning as you encounter these decisions that need to be made. Using the cube elements doesn’t change your planning, it just makes it easier. There’s no need to start from scratch each time an opportunity or challenge presents itself, just use the elements as your guide to ensure that you’ve considered everything you need to and the outcomes that you expect would be produced.

Manage by Exceptions

How long would it take you to review every line item on your financial statements each month?

Answer: More time than you have.

To understand the impact of the budgets and what-if scenarios you create you need to manage by exception, just as you do with your financial statements each month. Watch your ratios, volumes, and the dollars that fall out of line with your expectation.

Perpetual Budgeting

It may seem like it’s an ominous chore but perpetual budgeting lets you relax and continually keep your budget in line with your strategic plan.

Rather than the several-months-long process that budgeting usually takes, it’s easier stay on top of your strategic goals, evaluate progress, and make needed adjustments when your budget is truly a forecast; a dynamic document that includes your assumptions, comparisons with reality, and can easily be utilized for what-if scenario planning.

How can you apply the cube elements to a decision you need to make? Use these budgeting hacks to make your life easier.

Businesses of every description rely on the Budget Maestro™ family of software solutions by Centage Corporation to improve the efficiency and effectiveness of their business budgeting and planning, financial forecasting, financial consolidation and reporting processes. For more information, take a tour of Budget Maestro, contact Centage, or call 800-366-5111 now.

https://www.centage.com/wp-content/uploads/2022/10/Cubes-scaled-1.jpg 1440 2560 Jason Lin, CFO /wp-content/uploads/2022/10/Group-780.svg Jason Lin, CFO2017-02-01 15:17:372022-11-28 13:32:22Budgeting Life Hacks: OLAP Cubes Make Budgeting Easier
Back to List

Also by This Author

  • Report the Future: The Role of Automation in Financial Reporting
  • Best Practice Tips to Impress in the Role of CFO
  • Why Cash Flow Is Vital for SMBs
  • Cash Flow Forecasting: The Key to Future-Proof Your Business for 2022
  • Why Financial Forecasting Is More Important Than Your Annual Budget

View Demo Video

Request a Quote

Centage Corporation
330 Cochituate Road, #807
Framingham, MA 01701
P: 800.366.5111

  • Product
  • Industries
  • Integrations
  • Resources
  • Company
  • Contact
  • Help Hub
  • Watch Demo
  • Request a Quote

© 2022 Centage

Privacy Policy

Terms of use

Sitemap

  • Product
    • Planning Maestro
      • Product Overview
      • Watch Demo
      • Schedule a Live Demo
      • Plans
      • Service & Support
      • Back
    • Capabilities
      • Consolidation
      • Budgeting
      • Forecasting
      • Scenario Planning
      • Performance Dashboards
      • Financial Reporting
      • Back
    • Back
  • Solutions
    • Industries
      • Nonprofit
      • Healthcare & Life Sciences
      • Finance & Insurance
      • Manufacturing & Distribution
      • Retail & Hospitality
      • Software & Technology
      • Other Industries
      • Back
    • Integrations
      • QuickBooks Online
      • Microsoft Dynamics 365
      • Sage Intacct
      • NetSuite
      • Abila
      • Other Integrations
      • Back
    • Back
  • Resources
    • All Resources
      • Our Blog
      • Webinars
      • Whitepapers & E-Books
      • Videos
      • Customer Case Studies
      • Back
    • Back
  • Company
    • About Us
    • Leadership Team
    • Partners
    • Press & News
    • Awards
    • Careers
    • Back
  • Contact

    Quick Links

  • Help Hub
  • Watch Demo
  • Request a Quote

Stay Informed