Cognos Tutorial Overview
Welcome to the Cognos Tutorials by Cognos Experts. The intent of these tutorials is to provide in depth understanding of Cognos Tools.
In these tutorials, we will cover topics such as Roles, Filters, Data Acquisition, Project Creation and DataSources etc. We will also discuss in detail about Report Studio and Query Studio
In addition to Cognos Tutorials, you can find interview questions, how to tutorials and issues and their resolutions.
Introduction of Cognos
IBM Cognos Business Intelligence is a web based reporting and analytic tool. It is used to perform data aggregation and create user friendly detailed reports. Reports can contain Graphs, Multiple Pages, Different Tabs and Interactive Prompts. These reports can be viewed on web browsers, or on hand held devices like tablets and smartphones. Cognos BI reporting allows you to bring the data from multiple databases into a single set of reports.You can create and schedule the reports and complex report can be designed easily in the Cognos BI Reporting Tool.
What is Cognos business intelligence?
Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports.
What is Cognos software?
IBM Cognos Business Intelligence is a web-based, integrated business intelligence suite by IBM. It provides a toolset for reporting, analysis, scorecarding, and monitoring of events and metrics. The software consists of several components to meet the different information requirements in a company.
These core tutorials will help you in learning the fundamentals of Cognos.
For an in-depth understanding & practical experience, Explore Cognos Online Training
Cognos Report Studio
Report Studio is a Web-based tool that professional report authors use to build sophisticated, multiple-page, multiple-query reports against multiple databases. With Report Studio, you can create any report that your company requires, such as invoices, statements, and weekly sales and inventory reports.
Using Report Studio, report authors create, edit, and distribute a wide range of professional reports. They can also define corporate-standard report templates for use in Query Studio, and edit and modify reports created in Query Studio or Analysis Studio
. Use Report Studio for reports that
-Are intended for a wide audience
-Exist long enough to require maintenance for changing requirements and data
-Require detailed control over the appearance
Report Studio provides powerful functionality, such as bursting, prompts, maps, and advanced charting, and provides many ways to customize reports.
Working in Report Studio
To create reports in Report Studio, you must become familiar with the Report Studio environment.
To work effectively in Report Studio, do the following:
-Familiarize yourself with the user interface.
-Learn about basic report structure, which includes the layout and queries.
-Learn how to work with report objects.
-Set the options you want.
Basic Report Structure
All reports have two components, a layout component that defines the report appearance, and a query component that defines report data. Understanding these components will help you design effective reports.
A layout is a set of pages that defines the appearance and formatting of a report. When you design the layout of a report, you
-present the data in a meaningful way by using lists, crosstabs, charts, and maps.
-give the report the appearance you want by adding formatting, such as borders, color, images, and page numbers.
-specify how the data flows from one page to the next.
Pages are containers for the layout objects that you use to build a report. A page is made up of the following mandatory and optional components:
-page header (optional)
-page body (mandatory)
-page footer (optional)
When you run a report, the amount of data queried often exceeds one page. As a result, a page will repeat until all the data is shown. You have control over how data flows from one page to the next.
Queries determine what data items appear in the report. Sometimes you want detail rows of data, which you obtain by using a simple SELECT statement. Other times you must calculate totals or averages using aggregate functions and grouped columns, or must apply filters to show only the data you want.
Report Studio automatically creates the queries you need as you build reports. However, you can modify these queries or create your own custom queries to get the results you want.