Report Studio is a web-based tool that is used by report developers to create multi pages, complex reports on top of multiple data sources. You can create sales reports, inventory reports, account statements, balance sheets, etc.

How to Create a Report in Report Studio?

To create Reports in Report Studio, you should have a good understanding on user interface. Report Studio user interface is divided into two parts −

• Explorer Bar on the Left Side.
• Work area for report design.

The above screenshot has three major blocks, which are as follows −

• Insertable Object Pane − The Insertable Objects pane contains objects that you can add to a report. These objects can be added by dragging them to the work area. It can contain −

o Source tab (That contains item from the package).
o Data Items (Queries created in the report).
o Toolbox (different objects like graphics that can be added to the report)

• Properties Pane − The Properties pane lists the properties that you can set for an object in a report. To get the help, select the property and use keyboard key F1.

• Work Area − The work area is known as the area where the report is designed.

How to Open Report Studio?

On the home page, go to Launch → Report Studio → Select a Package or in the IBM Cognos Welcome page, click on Author advanced reports to open Report Studio.

How to create report in Report Studio

On the home screen of Report Studio, you have an option to create a new report or open an existing report.

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

Cognos – Report Templates

In Report Studio, you can create different types of reports. They allow you to present the data in different formats like a list report can be used to show the customer information.

The following reports can be created in Report Studio −

List Report

This report is used to show the data in detailed format. Data is shown in rows and columns and each column contains all the values of a data item.
Quarter Order number Quantity Revenue

Q4 101035 105 $4,200.00
101037 90 $8,470.80
101044 124 $11,479.92
101052 193 $15,952.42
101064 58 $5,458.96
101065 78 $7,341.36
101081 145 $5,800.00
101092 81 $7,623.72
101093 50 $4,706.00
101103 139 $5,560.00

Crosstab

Like list report, a cross tab report also shows the data in row and columns, but the data is compact and not detailed. At the intersection points of rows and columns, you show the summarized data.

Chart

You can use the Report Studio to create many chart types, including column, bar, area, and line charts. You can also create custom charts that combine these chart types.

Map

You can also use maps in the Report Studio to present data for a particular region, country or a location.

A map report consists of three parts −

• Region Layer
• Point Layer
• Display Layer

Repeater

Repeaters are used to add repeat items in a report while running the report. To add a Repeater, drag a repeater from the tool box to work area.

Cognos – Creating a Chart

In Report Studio, you can create many chart types like column, bar, area, line charts or a custom chart that combines these chart types.

How to create report in Report Studio

In the Source tab, expand the query.

• Drag Revenue to the Measure (y-axis) drop zone.
• Drag Current year to the Series drop zone.
• Drag Order to the Categories (x-axis) drop zone.

Drag the objects as shown in the above screenshot.

Save the chart using the tool bar at the top. Save it to Public or My Folder as mentioned in the previous topic. Run the report to see the result in a chart format.

You can also create a Repeater table or a map report in Cognos Report Studio.

So, this brings us to the end of blog. This Tecklearn ‘How to create report in Report Studio’ 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

538