TM1 Insight

TM1 - Table Manager One

      TM1 is an IBM product which helps people to forecast/budget the data such as company plans for labor, projects, travel and other expenses etc.

1) TM1 helps the business to create and maintain the Multi Dimensional database.

2) TM1 helps the business to store both actuals and forecasting data and reports to the users.

3) TM1 clients interfaces are -

* Excel add-on (TM1 Perspectives)
* Web browser (TM1 Web)
* TM1 Architect (Server Explorer)

4) TM1 has built-in ETL (Extraction, Transformation & Loading) to perform data movement from source to multi dimensional cubes.

5) TM1 can pull the data from ODBC, Text, Excel and TM1 own Cubes and it also have the capability to write back the source databases.

TM1 consists of the following objects

 I)  Dimension
II)  Cube
III) Applications
IV) Processes
V)  Chores


I) Dimension - Dimension holds the description data. Ex. What is the product code, name, category etc.,

2) The Dimension can be loaded either manually or through a process within TM1. Once the dimensions get loaded the Cubes can be loaded and the data will be shown across available dimensions.

3) Individual Applications can be created by selecting the required Dimensions & Cubes from the list and users will be able to access them.

For Example: If we want to have R&D application related dimensions & cubes in one place, we'll create R&D Application under Applications and choose the required objects under this.

4) Processes are the the ETLs(Extractions, Transformation & Loading) in TM1.

5) Chores hold the processes and schedule to run at a particular date & time.