Differences between Cognos TM1 and Cognos 10 BI

What are the differences between Cognos TM1 and Cognos 10 BI? Which one is considered by IBM as an IBM tool?

+4
source share
5 answers

There are huge differences between Cognos TM1 and Cognos 10 BI!

Cognos TM1 is a multi-dimensional database (OLAP) that can be requested from Excel and the Internet through the TM1 Web, TM1 Executive Viewer, and Cognos 10 BI. In this database, you can create almost any OLAP / Decision application.

Cognos 10 BI is a web reporting application. Users, depending on their rights (licenses), will be able to run reports, schedule reports and / or create ad hoc analysis against relational and / or multidimensional databases. To do this, create a logical layer using the "Framework Manager". This logic level is used to hide the complexity of the database and provide information to end users.

+11
source

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.

+2
source

The key difference is that Cognos TM1 is designed to work with excel easily, because Cognos 10 BI is mainly browser-based. Check out the gory details here. http://www.tm1forum.com/viewtopic.php?f=5&t=1442

0
source

Cognos TM1 is also referred to by IBM as FPM Financial Performance Management. This is a cubic MOLAP application in memory with real-time rule calculation. Since it provides feedback to the end user, it is often used by the Department of Finance for budgeting and modeling, therefore, the MS Excel interface is often used. However, it also comes with a β€œfront end” with a zero position, as well as Cognos Insight, which allows you to distribute or disable access to TM1 cubes (server-side).

TM1 can be integrated into Cognos BI, so Cognos BI reports TM1 cubes; or TM1 can be obtained from the portlet on the Cognos BI toolbar.

0
source

the difference between cognos10 and cognos tm1: -BI is a reporting tool, and cognos tm1 is an analysis and reporting tool, in tm1 bulid CUBES and BI generate reports

0
source

Source: https://habr.com/ru/post/1433174/


All Articles