Simply put:
- TM1 is a database engine and a set of applications for accessing and managing databases.
- Cognos BI is a set of web applications that provide pretty interfaces for viewing and creating data with data.
Most often, Cognos BI uses TM1 databases as a data source, but this is not necessary. If Cognos BI uses TM1, most of the custom functions that are available in TM1 applications are also available through Cognos BI, except that they are more conveniently available. Cognos BI also adds functionality to non-TM1 applications to provide additional data management. IBM marketing is confusing, but typically Cognos BI and Cognos TM1 are seen as the BI toolkit they offer.
Now, to be a little more technical about TM1, this is not just a simple old database. As mentioned above, this is a multi-dimensional OLAP database. It is capable of handling numeric and string data, but does not have the concept of NULL values. Numeric data can be summarized using consolidated elements. It has attributes for storing metadata. It has a built-in rule engine for processing business logic and user computing. It has processes for ETL and database maintenance tasks. He performs tasks for scheduling processes at various intervals. He refers to Excel workbooks. Finally, in addition to these features and more, which are provided out of the box, TM1 provides an API for programming against the use of 3GL, such as C ++, C #, Java, and even VBA.
source share