Common questions

What is Report Studio in Cognos?

author 0

What is Report Studio in Cognos?

IBM® Cognos® Report Studio is a Web-based report authoring tool that professional report authors and developers use to build sophisticated, multiple-page, multiple-query reports against multiple databases.

How do I access my Cognos Report Studio?

You access Cognos Report Studio in one of the following two ways:

  1. In the IBM Control Center console, click Tools > IBM Cognos Reports.
  2. In the IBM Control Center console, click Tools > IBM Cognos Connections. Select your reports and click Launch > Report Studio.

How do I use Cognos Report Studio?

Procedure

  1. Open IBM Cognos Connection:
  2. In the IBM Cognos Welcome page, click Author advanced reports to open Report Studio.
  3. Click Samples, Models, GO Data Warehouse (analysis).
  4. Click Create new, click Crosstab, and click OK.
  5. Insert data in the crosstab zones:
  6. Click Run Report to run your report and verify the content.

What is the difference between Query Studio and Report Studio in Cognos?

Report studio can edit query studio reports as well. So sometimes users save their Query studio reports but ask for developers to tweak them to get desired appearance/functionality. Both application generate XML files that are stored in the Cognos Repository.

How do I create a report in Cognos 10?

Procedure

  1. In the IBM Cognos Welcome page, click Author advanced reports to open Report Studio.
  2. Click Samples, Models, GO Data Warehouse (analysis).
  3. Click Create new, click Crosstab, and click OK.
  4. Insert data in the crosstab zones:
  5. Click Run Report.
  6. Insert another column in the report:
  7. Insert a chart in the report:

How do I write a SQL query in Cognos Report Studio?

Click the Toolbox icon, and to build an SQL query, drag SQL to the right of the query. Tip: You can drag SQL anywhere in the work area, and IBM® Cognos® Analytics – Reporting will automatically create a query. , and in the Properties pane, double-click the Data source property and click a data source.

How do I create a custom report in Cognos?

To create a report, expand the trees corresponding to the required database fields and select the fields to be displayed as columns in your report. Once you have created your report, you can edit the report, change the report layout, run the report in specific formats, and save the report.

How do I get SQL query from Cognos report?

Procedure

  1. To view the SQL for the entire report, click the Queries icon , right-click the Report icon. , and click Show Generated SQL/MDX. This option shows the SQL that will be executed in the data source.
  2. To view the SQL for a specific query, do the following: Click the Queries icon, and click the query.

How do I write a report in Cognos?

author

Back to Top