IBM Cognos BI is a suite of Business Intelligence most used. It is a fairly complete BI software, yet manageable, and one of the BI market leaders. The main applications are used from a web portal that controls the Business Intelligence Server, which is the heart of the tool.
This portal is called Cognos Connection and from the same, provided by web, accessing management options environment and services to the different applications that provides Cognos BI, to the folder structure that reports are organized , to dashboards, and other accessories that can be integrated into the portal. Get a FREE demo on Cognos Training from real time expert trainers.
Each application is designed to cover a type of needs that often occur in such environments. Most handles 100% from the web browser, both to develop and design reports, events and metrics to consult or analysis tasks.
These are the main tools provided in the suite:
- IBM Cognos Query Studio
- IBM Cognos Report Studio
- IBM Cognos Analysis Studio
- IBM Cognos Event Studio
- IBM Cognos Metric Studio
- IBM Cognos Powerplay Transformer
- IBM Cognos Framework Manager
- IBM Cognos Planning
- IBM Cognos TM1
IBM Cognos Query Studio
It is the simplest tool and could be considered rather as a complement. Its goal is to allow the user to perform simple to quickly resolve specific issues that may arise queries. It allows access to the same data structure used by other tools, whether it is a relational model as if the structure is dimensional.
With Query Studio can create a report in seconds by dragging fields from the Data Explorer to the report design area. Also it lets you apply filters, sorting, grouping of data operations and even create graphs. It also has formatting options, although quite limited.
Where is more limited it is precisely in formatting the report, and the creation of complex calculated fields, using benchmarks and many other advanced options for which is to be used Cognos Report Studio.
IBM Cognos Report Studio
It is the main application for creating reports from IBM Cognos BI. It resembles Query Studio, but is much more complete.
On the left shows an object browser from which you can access the data structure, and other insertable objects in reports. To the right is the report design area where you can drag these objects and go and composing the structure.
These objects can be of different types: data source, specifics of the report and design tools. Each object that is embedded in the report has its configurable properties, and through these you can reach a very high level of customization, both in the data shown in the design of the format.
It can work both structures of relational and with dimensional data structures, just keep in mind that depending on the type of origin there aredifferences in the properties applicable to the data, and even in behavior in the design area . Although not required to do so, to show dimensional structure data, it is more appropriate to use crosstab type reports. You can choose from several types of basic structure for reporting.
There are different types of graphs, and even maps that can be included in reports, display or store individually to form part of a scorecard that would be displayed in the portal.
The options of using parameters and prompts are also fairly complete, although how they are defined is not very intuitive and is somewhat cumbersome.
As in all these types of tools, you can define filters, sorting, grouping and working with aggregates, create subtotals, calculated fields, conditional formatting. You can also enable the drill up and drill down, and using drill through.
Consultations done with the operational origins SQL and MDX dimensional models used. The resulting query can be viewed and even edited and changed directly.
IBM Cognos Analysis Studio
Analysis Studio is similar to Query Studio function, but for multidimensional sources. This tool allows navigation structures such as multidimensional OLAP cubes that do not necessarily have to be of Cognos BI. You can also attack relational data sources, provided they are dimensionally modeled from IBM Cognos Framework Manager.
The main purpose of this software is to enable the business analyst can 'navigate' by the data loaded into the dimensional structures without relying on IT support area. As announced by the manufacturer using Analysis Studio a business user can perform complex analysis and comparative data to discover trends, risks and opportunities.
The work area is similar to that of Cognos Query Studio and Cognos Report Studio and standard options for creating reports are very similar to Query Studio, applying filters, sorting, grouping operations data, creating charts , etc.
It also offers more functionality dimensional oriented sources, such as navigation with drill up / drill down or filter the creation of context.
IBM Cognos Event Studio
This is the tool of notifications and alerts from IBM Cognos BI suite. With Event Studio agents are checking the data or KPI's defined are created, and detect major events for the business when certain values are reached or certain conditions are met.
At that time the tool proceeds to execute actions or tasks that have been associated with the events. You can run or distribute reports, generating emails, communicate with other software tools, or other agents to run jobs, call stored procedures database, or even call a Web Service.
Once constructed agents Event Studio, with the same environment Scheduler used to schedule automated execution of reports, and periodic program execution thereof is controlled.
IBM Cognos Metric Studio
It is the software that is used for the construction of metrics and dashboards. With Metric Studio are defined KPIs or business performance Key Indicators, are organized and relate to each other, they are associated with different profiles, and monitor, allowing compare all objectives moment versus performance, and define automated actions such as notifications in case of deviations.
With these metrics dashboards that enable operational level to monitor performance against objectives, and strategic level "map" of corporate strategy and facilitate its transmission to all levels of the organization are built.
The metric can be constructed from different data sources, such as OLAP cubes, relational databases, spreadsheets, text files, and even values manually informed, and the tool features wizards to facilitate the construction of metrics and dashboards.
IBM Cognos Powerplay Transformer
The above tools provide access to OLAP cubes as a data source. BI software IBM Cognos Powerplay Transformer is the tool to build OLAP cubes, called IBM Cognos PowerCube. Although reporting tools IBM Cognos BI can work in and attack ROLAP relational databases, to perform analytical tasks it is often most efficient to use an OLAP cube as a data source, ie work in MOLAP. With a data volume controlled response times in the use of reports can be much better.
With Powerplay data sources are defined, the multidimensional structure which will shape the cube is modeled, validated, and proceeds to its construction.
This tool is installed in client mode, not accessible via web. It is used independently to generate cubes, which is attacking the other web tools.
IBM Cognos Framework Manager
It is Cognos BI software that is used to build the necessary metadata for all other work. It not often mentioned as a product because it is using the technical area to create the packages metadata reporting tools consult to show the business user an intelligible structure, and allow create a navigation tree just by consulting data systems origin.