Query Studio in IBM Cognos

29 October, 2018

Ratings

Related Blogs

It is a web based component used to create simple reports (or) Adhoc reports (or) self service reports (or) Instant reports.

It is end users (client) studio.
The full query is types of reports can be generated by using query studio.

List report
Crosstab report
Chart report.

Ex: Create a simple list report with order year, order month, qty and revenue by using query studio.

Open the IE browser to access the query studio.
Enter the following URL http://IBM Cognos
From welcome page select “Query my data” (query studio)
Select the package go sales and retailers.
Drag order year, order month, qty

Drop on work area.

Eliminating duplicates:

Use group options to eliminate duplicates and to display group totals.
Select order year data item in the list report.
From menu change layout select group

Ungroup: It is used to restore the duplicates.

Select order year ungroup

Collapse group: It is used to hide (or) collapse the details of a group.

Select order year in the list report.
From change layout menu --> select collapse group.

Expand group: To restore the details of a group

Select order year from change layout menu expand group.

Create sections: It is used to divide a report into number of sections.

Select order year in the list report.
From change layout menu select create sections/

Set page breaks: To create page breaks for each and every section to display single page.

Select order year apply set page breaks.

Set web page size: It is used to set a number of rows per each and every page. Edit title area: To specifies the title name to the report. Change font styles: It is used to set the required color and fonts. Pivot: It is used to connect a list into crosstab.

Create a list report with order year, order method, qty, and revenue.
Select order year from change layout menu.
Select pivot

These core tutorials will help you to learn the fundamentals of Cognos. 
For an in-depth understanding and practical experience, explore Cognos Online Training

Swap rows and columns:

It is used to convert rows into columns and columns into rows in a crosstab. Chart: It is an option used to convert a list (or) crosstab into a chart report. Define conditional styles: It is used to perform simple conditional formatting.

Create a list report order year, order method, revenue
Select revenue
From change layout menu select define conditional styles.
New value 1000000 insert
Styleexcellent
New value 500000 insert
Style average
New value 50000 insert
Style poor

Template:

It is a predefined structure that can be reused for multiple reports.

Use report studio to create templates.

Creating a template:

Open report studio with gosals and vectors package.
From file menu select new, select template.
Double click to edit text ABC limited.
Subtitle India
Select page explorer click on ‘classes’
From global class extension list column body cell.
Set the required color, font by using font property.
Select list column title call set the required template file menu, click on save under your folder with the required name.

Applying template:

Open query studio with gosels and retailers.
Create a list report with country, product link, and qty and revenue order method.
From change layout menu select apply template
Apply a template
Select Template --> browses your required template.
And select the template --> ok

Define custom groups:

It is used to compare one element in the attribute with remaining elements in the attribute. Ex:

Create a list report with order method, revenue.
Select order method
From edit data menu select define custom groups.
Enter the new group name email_group add from available values email add.
Create another group others_group add
From available value select all values add
Click on ok
Select order method data cell click on delete.
Select revenue - click on ‘calculate’ option
Operation type percentage
Operation - % of total
Report type revenue
% of total

For indepth understanding Cognos Training click on

About Author

Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .