IBM Cognos 8 BI
TomL1983 270003K909 1,865 Views
I am creating a report compiled of 5 list queries. when the report runs I cant seem to get the items to line up underneath each other. Any tips on how to do this?
ManikanthVangala 270006X2SQ 1,627 Views
I am new to Cognos :(
I have requirement like ::
I am showing country names in a world map of cognos. But user want to see continent names insted of country name. Could you guyz please help me..
Ahmed Abdel-Baky 2700014X0Q Tags:  try cognos test developerworks free 3 Comments 5,616 Views
You can practice IBM Cognos Analytics on the cloud from the following URL:
You can login using your IBM ID.
There, you can test -for free- the latest version of:
I will try to collect here some resources about connecting Cognos to VSAM files (from System Z).
Any help/comments are appreciated.
Satish@Melimi 310001PTB8 1,323 Views
gk6565 50N16VP246 1,917 Views
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
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.
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.
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.
TejaswiniUL 310002QN5Y Tags:  your tool ibm cognos data dynamic reports intelligence business warehouse make 1,471 Views
Business Intelligence (BI) tools such as Cognos are good at fetching data from a database and displaying the data on a web page. This post details how you should put some of your HTML reporting components in your data warehouse to give you a flexible and easily maintained set of components to include in all your reports. Even though I am writing this post using Cognos as an example, you can use this technique for any BI tool that is accessed by a web browser. That should be 90% of all BI tools.
Perhaps because I do not do it often enough, I find creating custom Cognos templates tedious. The process involves iteratively modifying XML documents, modifying cascading style sheets and quite often you need to restart the Cognos server to see the changes. This process has to be repeated with every Cognos upgrade to make sure your templates continue to work well. To reduce the technical dept incurred when you create custom Cognos templates I suggest storing some of your report specific templating components as HTML in your reporting database or data warehouse . This tip does not apply to the overall Cognos portal but items in each reports created in Report Studio.