How to create List and CrossTab Report in Cognos

Last updated on Sep 27 2021
Jatin Gupta

Table of Contents

How to create List and CrossTab Report in Cognos

Cognos – List Report

A list report that shows the data in rows and columns and each cell shows the data in the database or you can also add custom calculations in a list report.

To create a new list report, go to New → Blank as shown in the following screenshot.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

When you select a list report, you get the following structure of the report in the Report Studio. You have to drag the objects from the package on the left side to the report structure.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

You can also edit the title of the report that will appear once you run the report.

How to create List and CrossTab Report in Cognos

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

You can use different tools at the top for the report formatting. To save a report, click on the save button. To run a report, click on Run report.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

Once you save the report, you have an option to save it in the Public folder or My folder.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

When you click on the Run option, you can select different formats to run the report.

How to create List and CrossTab Report in Cognos

How to create List and CrossTab Report in Cognos

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

Cognos – Crosstab Report

You will be prompted to select the type of report you want to create. You have option to select from different report types.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

Select Crosstab as type of the report and click OK.
The structure of a Crosstab report is opened as shown in the following screenshot.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

In the Insertable Objects pane, on the Source tab, click the data item you want to add to the crosstab and drag it to the Rows or Columns.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

A black bar indicates where you can drop the data item. Repeat the above given steps to insert additional data items.
You add dimensions to rows or columns and to add measures to the crosstab, drag the measures you want to Measures.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

When you run the report, a crosstab report is generated that has one edge.

Formatting a Crosstab

You can also format the crosstab to give them appearance as per the requirement. When you specify formatting for all rows, columns, fact cells, or the crosstab, the formatting is automatically applied to any new items you add.

Crosstab Style order

When you apply styles such as font color, rows and columns, intersections this is applied in the following order.

• Crosstab fact cells
• Fact cells in the outermost rows
• Fact cells in the innermost rows
• Fact cells in the outermost columns
• Fact cells in the innermost columns
• Crosstab intersections

To do formatting of crosstab, click anywhere in the Crosstab. Click the select ancestor button in the title bar of the Properties pane and then click Crosstab as shown in the following screenshot.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

In the Properties pane, click the property you want and then specify a value. For example, if you want to specify a background color, click on Background Color and choose the color you want to use.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

You can also right-click the row or column and click Select Member Fact Cells. In the Properties pane, click the property you want and then specify a value.

How to create List and CrossTab Report in Cognos
How to create List and CrossTab Report in Cognos

So, this brings us to the end of blog. This Tecklearn ‘How to create List and CrossTab Report in Cognos’ blog helps you with commonly asked questions if you are looking out for a job in Cognos BI. If you wish to learn Cognos Analytics and build a career in Business Intelligence domain, then check out our interactive, IBM Cognos Analytics Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

IBM Cognos Analytics 11 Training

IBM Cognos Analytics 11 Training

About the Course

IBM Cognos 11 training provides in-detailed knowledge on how to build complex and advanced reports and dashboards using IBM Cognos reporting tool, and this will enable you to become a Cognos developer. Major topics of this Cognos reports and dashboard training include Cognos architecture, the components of Cognos, Analysis Studio, OLTP system, Query Studio, advanced report designing, Cognos Framework Manager and Cognos Administration. By the end of this training, you will get an insight into working with IBM Cognos reporting tool by implementing real-time Cognos projects, and you will be able to use this knowledge in real-time environments.

Why Should you take IBM Cognos Analytics 11 Training?

• The average Cognos developer salary is $78417 or an equivalent hourly rate of $38-Erieri.com.
• Cognos has a market share of around 9% globally.
• Cognos Analytics V11 enhances the efficiency and capabilities of business users, report authors, and administrators alike through a simplification of and the graduated nature of its user experience.

What you will Learn in this Course?

Overview of IBM Cognos BI and Cognos BI Architecture

• Overview of IBM Cognos Analytics 11
• IBM Cognos Framework Manager Modelling
• New UI features of Cognos Analytics 11

Cognos Analytics 11: Data Modules

• Overview of Cognos Analytics 11 Data Modules
• Creation of Data Server Connection
• Using Data Modules to modulate data without using the Framework Manager
• Data Discovery through intent-based modelling
• Creating Data modules with inputs from various sources

Working with Dashboards

• Process of Dashboarding in IBM Cognos
• Creating a Dashboard
• Filter Data in Dashboard
• Widget-to-Widget Communication
• Sorting, Grouping and Calculating Data
• Storytelling

Cognos Environment

• Active Report
• New Visualization Types
• Sharing and Embedding Contents

Cognos Reports

• Cognos Report Studio
• Reporting using Filters, Formatting, Charts
• Advance Report Building Techniques
• Cognos Active Reports
• Geo Spatial Analytics

Cognos Administration

• Deep Dive into Cognos Administration
• Analysing and Administering Queries

Dimension Modelling

• New Features in Smart Modelling
• Transformer Cube and Drill through
• Dynamic Cube and Drill Though

 

0 responses on "How to create List and CrossTab Report in Cognos"

Leave a Message

Your email address will not be published. Required fields are marked *