Query Studio in IBM Cognos

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.

1. List report
2. Crosstab report
3. 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 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

• Cognos Tutorials
• Introduction to IBM COGNOS
• Dimensions & OLAP Types in Cognos
• Fitters and its types in Cognos
• Schemas and its types in Cognos
• Cognos Training In Bangalore