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.
- 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