TM1 is the one product of IBM, The full name of TM1 is Table Manager One, Yes the concept of TM1 is keep all data on memory, Build cube, Build dimension that very easy and it create for supporting financial and budgeting planning.
For the concept to keep all data in memory, that helpful, you do not need to process cube if you want generate any report, very simple and fast then other product, They said ^_^.
There are many ways to enter to TM1 for many reason
1.TM1 Architect
This work space is comfortable for programming, and some super user to get inside for key in data, budget, you can create cube, dimension, create formula, codding in this product.
2.TM1 Perspective
It still look the same like TM1 Architect but the only one is different it because you can export your job from here to excel or slice your job to excel with formula then you can work on excel, if you selected to slice that mean every formula will export to excel also, whatever you have change from excel, it'll make effect to TM1 Architect automatically, So why IBM have to create this product?.
3.TM1 Application
It's a web application and it the way to get inside to project. You can create work flow on this product but you can not create cube or build any dimension on here, user also can key in data on this space.
4.TM1 Web
I'm still not sure why they need to separate this section from TM1 application product because every thing seem like the same, but the different one is you can not create work flow on here, that it's!?
5.TM1 Insight
Yes if you want to work in off line, you have to install TM1 insight on your computer but that not helpful, U can not sick your job to server after you have done automatic, it need special way to do, every thing feel the same TM1 application, but you just can create or import cube and dimension from here then I still not get why IBM have to create many window to inside work space that too trouble.
Let's see compare between TM1 and SQL Server Analysis Service
| List | TM1 | SQL server analysis services |
| Brand | IBM | Microsoft |
| Build Cube | Yes | Yes |
| Process Cube | No | Yes |
| Make data relation table | Yes | Yes |
| User Friendly | Poor | Nice |
| Programmer Friendly | Poor | Nice |
| In memory | Yes | No |
| Fast | Depend on data | Depend on data |
| Database | No | SQL Server |
| Work Flow | Yes | No |
| Off Line Mode | Yes | No |
| Recouse | Height Speed | Heidht Speed |
