Understanding the TM1 database technology that takes Excel capability to the enterprise
Presenting the Functional Model
Despite its flexibility, Excel alone cannot solve complex, forward-looking business modelling problems associated with budgeting, forecasting and financial reporting on large data sets or when collaboration among many people is needed. TM1 takes the concept of Excel and applies it at a robust database level – leveraging Manny Perez’s technological advancement known as the functional database.
An easy way to think about a Functional Database is to imagine it as millions and millions of neatly ordered, compact spreadsheets.
The functional model goes beyond conventional databases by using a cell orientation like Excel, complete with instant recalculations in memory. This approach is much more intuitive to business users.
IBM’s TM1 is the most robust and mature Functional Database that uniquely allows interactive budgeting, forecasting and financial reporting. The TM1 Functional Database provides the same cell-oriented concepts as Excel, but allows thousands of users, terabytes of data and deeply complex modelling to match business needs – enabling the concept of cubes in TM1 models.
In the same way that any cell in an Excel workbook can be a function of any other cell in any Excel workbook, any cell in any TM1 cube can be a function of any other cell in any TM1 cube. It is this fundamental property that makes them such intuitive and powerful business modelling tools together.