Introducing IBM Cognos BI, Business Intelligence suite of IBM

IBM Cognos 8 BI is a suite of business intelligence used more widely. This software is fairly comprehensive, but manageable, and a leader of the BI market.

The main applications are used by a web portal that controls the Business Intelligence Server, which is the heart of the instrument.
This portal is called Cognos Connection and the same, provided by the web, you can access the environmental management options for different applications and services that provides Cognos, the folder structure that organizes the reports, dashboards and other accessories that can be integrated in the portal.
Each application is designed to cover a type of needs that often occur in such environments.Most deals 100% web browser, is to develop and design reports, events and metrics for review or analysis tasks.
These are the main tools in the suite:

IBM Cognos Query Studio

It 's the easiest, and could be seen rather as a complement.Its purpose is to allow the user to perform simple queries to quickly solve specific problems that may arise.
Provides access to the same data structure used by other tools, if it is a relational model, as if the structure is dimensionally.
With Query Studio can create a report in seconds by dragging the field to explore data for the area of ​​the report design. It also lets you apply filters, sorting, grouping of data operations and even create charts. Hto also options for formatting, but rather limited.
Where is specifically limited in the formatting of the report, and the creation of complex calculated fields, using benchmarks and many other advanced options that have been using Report Studio.

Creación de informes con Query Studio, de IBM Cognos BI

IBM Cognos Report Studio

It is the leading application for creating reports.Query Studio is similar, but it is more complete.
On the left shows an object browser from which you can access the data structure, and other items included in the report. To the right is the area of ​​design reports that you can drag these objects and compose the structure.
These objects can be of different types: the data source, specific to the report, and design tools. Every object that is embedded in the report has configurable properties, and through these we can achieve a high level of customization, both in the data shown in the drawing of the layout.
You can work with both relational data structures such as dimensional structures, just keep in mind that depending on source type, there are differences in the properties for data, and also in the conduct of design.Although not required to do so, to show the data structure size is more appropriate to use such reports crosstab. You can choose between different types of basic structure for reporting.
There are different types of charts, maps and even that may be included in the report, display or store individually to be part of a card that will be displayed on the site.
The options for the use of parameters is also presented and fairly complete, although the way they are defined is not very intuitive and is somewhat cumbersome.
As in all of these tools, you can define filters, sorting, grouping, and working with aggregates, create subtotals, calculated fields, conditional formatting. You can also turn the drill and drill-down, and using drill.
The consultation done with the origins of operational models used for SQL and MDX dimensional. The resulting query can be viewed and edited directly and also changed.

Diseño de un Informe con Report Studio de IBM Cognos

IBM Cognos Analysis Studio

Analysis Studio is a feature similar to Query Studio, but for multidimensional sources.This tool allows navigation structures such as multidimensional OLAP cubes, which may not necessarily be of Cognos. It can also attack the sources of relational data, provided that they are dimensionally modeled Framework Manager.
The main purpose of this software is to enable the business analyst can 'navigate' between the data loaded in three-dimensional structures without the need for IT support area. As announced by the manufacturer through analysis of a userBusiness Studio can perform complex analysis and comparative data to discover trends, risks and opportunities.
The work area is similar to Query Studio and Report Studio and options for the creation of standard reports are very similar to Query Studio, applying filters, sorting, grouping the data transactions, creating graphics, etc..
It also offers more functionality dimensional oriented sources, such as navigation with drill up / drill down or filter the creation of the context.

Diseño y ejecución de informes con Analysis Studio de IBM Cognos BI

IBM Cognos Event Studio

This is the tool of the suite of alerts and notifications.
With Event Studio creates the agents are checking the data or KPI's defined, and detect events of importance to the task when you reach certain values ​​or certain conditions.
At that time, the instrument proceeds to execute actions or tasks that are associated with events.You can run and distribute reports, generating emails, communicate with other software, or other agents to run jobs, call stored procedure in the database, or addirittura call a Web Service.
Once built Agents Event Studio, the same planning environment, you can schedule reports to run automatically, the program and monitoring the performance of their regular.

Creación de Eventos con Event Studio de IBM Cognos BI

IBM Cognos Metric Studio

And 'the instrument used for the construction of metrics and scorecards.
Studio metric defines KPIs Key Performance Indicators or business, are organized and relate to each other, are associated with different profiles, and monitor, allowing any time for comparison with performance objectives, and define automated actions, such as tender in case of deviations.
With these parameters are built 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.
The metric can be constructed from different data sources, such as OLAP cubes, relational databases, spreadsheets, text files, and also the values ​​manually, and the unit comes with wizards to facilitate the construction of metrics and dashboard.

Control de KPI's con Metric Studio de IBM Cognos BI

IBM Cognos Powerplay Transformer

The above tools provide access to OLAP cubes as a data source.IBM Cognos PowerplayTransformer is the tool to create OLAP cubes, called IBM Cognos PowerCube. Although Cognos reporting tools capable of working in attack and ROLAP relational databases, to perform the analysis is often more efficient to use an OLAP cube as a data source, the work that is MOLAP.With a volume control response time data, use of these reports can be much better.
Powerplay with defined sources of data and models multidimensional structure that forms the cube, validation, and proceeds to its construction.
This tool is installed in client mode, not accessible from the web. E 'used independently to generate the cubes, which is attacking web tools.

Creación de cubos OLAP con PowerPlay Transformer de IBM Cognos BI

IBM Cognos Framework Manager

This is the tool used to build the metadata needed for all other work.Not often mentioned as a product because it is the sector that uses the technique to package metadata query reporting tools to show business users intelligible structure, and allow navigation to create a tree just by looking at the system daots origin.


Optionally, the suite also provides other tools such as IBM Cognos 8 Planning and IBM Cognos TM1 , two tools designed to budgeting and financial planning, but every environment more suitable to a type.

TM1 technologyanalysis shows used memory, so you can get impressive response times.
Finally, let me mention the Express version of the Suite, IBM Cognos Express , IBM has developed the focus of small and medium-sized enterprises as more accessible and easy to implement.
I hope this little review of the product suite of IBM Cognos BI will be useful, each new contribution, opinions or comments are welcome in the section of the IBM Cognos BI Dataprix Forum.