Mindmajix

QUERY STUDIO – Cognos

QUERY STUDIO:

Query Studio is the reporting tool for creating simple queries and reports in IBM Cognos Business Intelligence.

In Query Studio, you can

  • View data

    Connect to a data source to view data in a tree hierarchy. Expand the query subjects to see query item details.

  • Create reports

    Use the data source to create reports, which you can save and reuse. You can also create a new report by opening an existing report, changing it, and saving it using another name.

  • Change the appearance of reports

    Improve the layout of your report. For example, you can create a chart, add a title, specify text and border styles, or reorder columns for easy comparison.

  • Work with data in a report

    Use filters, summaries, and calculations to compare and analyze data. Drill up and drill down to view related information.

To use Query Studio effectively, you should be familiar with your organization’s business and its data. You may also need to be familiar with other components of IBM Cognos Business Intelligence.

  • Designed for end users
  • Use query studio for creating simple ad-hoc reports and self service reports
  • To open the query studio
  • From Cognos home page,
  • Click on query my data
  • Click on Go Sales and Retailers

This tutorial demonstrates how you can create a list report, a pivot, and a template along with conditional formatting in Query Studio.

Create a list report:

  • Click on insert data menu
  • Drag the product line, product type, product name, quantity, revenue and drop on work area/report page
  • Select the product line
  • From change layout menu,
  • Click on group (Group eliminates the duplicates, automatically calculates sub totals, grand total)
  • Ungroup (Restores the duplicates)
  • Collapse Group – To suppress the detail data
  • Expand Group – To restore the detail data
  • Select the product line data item
  • From change layout menu,
  • Click on create sections
  • Page breaks  (By default 20 rows/page)

LIST REPORT

Screenshot_1028

Screenshot_1029

PIVOT (CROSSTAB):

  • Create a list report with the following query items
  • Product line
  • Order method
  • Quantity
  • Select the product line
  • Click on group icon
  • Select any item in the report
  • From change layout menu,
  • Click on pivot
  • Swap rows & columns

CROSSTAB REPORT

Screenshot_1030

Screenshot_1031

CONDITIONAL FORMATTING:

  • Create a list report with the following query items
  • Product line
  • Product type
  • Quantity
  • Select Quantity
  • Define conditional styles from change layout
  • New value — à  100000
  • Click on insert — à  50000
  • Click on OK

TEMPLATE:

Report Studio has predefined report templates that you select from, when you create a new report.

You can create your own custom report templates and make them available too.

  • Pre defined structure which can be reused/applied for multiple reports
  • Open the report studio,
  • Select report template
  • Click on OK
  • From page explorer,
  • Click on classes
  • From global class extensions
  • Select list column body cell
  • Select font property
  • Apply the properties
  • Select a list column title
  • Apply the properties
  • Click on save
  • Name the template (TCS)

Create a list report in query studio

  • From change layout menu
  • Click on apply template
  • Select the radio button, apply the template
  • Click on select a template
  • Select TCS template
  • Click on OK

 

0 Responses on QUERY STUDIO – Cognos"

Leave a Message

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

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.