• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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 arrrowchange layout arrrow select group

Ungroup:

It is used to restore the duplicates.

  • Select order yeararrrow 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 arrrowfrom 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 arrrow select define conditional styles.
  • New valuearrrow 1000000 arrrow insert
  • Stylearrrowexcellent
  • New value arrrow500000 arrrowinsert
  • Stylearrrow average
  • New value arrrow 50000 arrrow insert
  • Style arrrow 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 arrrow India
  • Select page explorer arrrow click on ‘classes’
  • From global class extension arrrow list column body cell.
  • Set the required color, font by using font property.
  • Select list column title call arrrow 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 arrrowemail_group arrrow add from available values arrrowemail arrrow add.
  • Create another group arrrow others_group arrrowadd
  • From available value arrrow select all values arrrow add
  • Click on ok
  • Select order method data cell arrrow click on delete.
  • Select revenue –arrrow click on ‘calculate’ option
  • Operation type arrrow percentage
  • Operation –arrrow % of total
  • Report type arrrow revenue
  • % of total

For indepth understanding Cognos Training click on

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Query Studio in IBM Cognos"

Leave a Message

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

Site Disclaimer, Copyright © 2016 - All Rights Reserved.