Beyond spreadsheets:
The Functional Database

Traditional spreadsheets aren’t well suited for bringing budgeting, forecasting, and financial reporting together at an enterprise scale. Discover the Functional Database, a new paradigm in financial planning and analysis.

See the Magic:
Interconnected Intelligence

In the same way that any cell in a spreadsheet workbook can be a function of any other cell, any cell in an IBM Planning Analytics / TM1 cube can be a function of any other cell in any cube. This fundamental property makes the solution so intuitive and powerful.

Click any cube to see how changes ripple through the entire system.

IBM Planning Analytics / TM1 is the most robust and mature functional database on the market. It’s unique for the way it enables interactive budgeting, forecasting and financial reporting all in one place. The functional database component uses the same cell-based concept as Excel, but allows thousands of users, terabytes of data and deeply complex modelling to match business needs - enabling the concept of “cubes” in financial models.

The Spreadsheet Struggle
is Real.

Every finance professional knows these struggles.

Version Control<br>Chaos

Version Control
Chaos

Working with version-controlled spreadsheet models makes it difficult to find a single, releiable source of truth.

Manual<br>Recalculations

Manual
Recalculations

Instead of instsant updates, stagnant spreadsheets require multiple manual interventions to keep them current.

Collaboration<br>Bottlenecks

Collaboration
Bottlenecks

It is difficult to collaborate on FP&A processes when teams are forced to work across disconnected sheets.

Traditional vs. Functional

A New Paradigm

Traditional Spreadsheets

Static, disconnected, error-prone

  • Stagnant, version-controlled models
  • Requires manual interventions
  • Difficult to collaborate
  • Limited scalability

Functional Database

Dynamic, interconnected, intelligent

  • Dynamic framework
  • Instant recalculations
  • Accessible by all users in real-time
  • A single system to keep current

Why Finance Teams choose
the Functional Database

Lightning-Fast<br>Updates

Lightning-Fast
Updates

Undertake instant recalculations as data changes.
This makes modelling more intuitive and efficient than ever before.

Data<br>Integrity

Data
Integrity

Leverage a single dynamic data framwork for sophisticated financial reporting and analysis, all in one place.

True<br>Collaboration

True
Collaboration

Allows thousands of users to work with terabytes of data and deeply complex models, using the same cell-based concept as Excel.

Jenny Bell

The training was excellent and Liesl explained everything very well, she cleared a few confusions I had from previous courses too. I really like the personal tips and hacks she shared in using TM1. Overall, Liesl is a very good trainer and the course was delivered very well in all aspects.

Ready to Transform
Your Financial Planning?

Here at Cubewise, we leverage the power of IBM Planning Analytics / TM1, the most robust and mature functional database on the market, to bring an entirely new concept to your FP&A needs.