Social Icons

Cognos Report Studio

Using Report Studio, report authors create, edit, and distribute a wide range of professional reports. They can also define corporate-standard report templates for use in Query Studio, and edit and modify reports created in Query Studio or Analysis Studio.

Use Report Studio for reports that

  • Are intended for a wide audience
  • Exist long enough to require maintenance for changing requirements and data
  • Require detailed control over the appearance

Report Studio provides powerful functionality, such as bursting, prompts, maps, and advanced charting, and provides many ways to customize reports.

Example- Create a Report

Use IBM Cognos Report Studio to create reports with complex layout, formatting, and report user interactions. Such reports are usually created by professional report authors who have a good knowledge of the data and tools.

In this exercise, you will learn how to:

  • Create a chart
  • Make the report interactive with prompts

You are a business analyst for the Sample Outdoors Company. You create a chart report in Report Studio to show the performance of returns over the last few years. You make the report interactive by adding a prompt. You will create a report that looks like the Report Studio sample Returns by Order Method - Prompted Chart in the GO Data Warehouse (analysis) sample package. To perform this exercise, you must have the appropriate licensing and security permissions for this functionality.

Things to notice:

  • When you use Report Studio, data is not live. You must run the report to view data.
  • You can view the XML report specification.
  • You can add multilingual capabilities.

1. Open IBM Cognos Connection:
a. Start your Web browser.
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos

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:
a. In the Source pane, expand Sales and Marketing (analysis), Returned items, Return reason, and Return reason. Drag Reason description to the Columns zone.
b. Under Returned items, expand Returned items. Drag Return quantity to the Measures zone.
c. Under Sales and Marketing (analysis), expand Inventory, Products, and Products. Drag Product line to the Rows zone.

6. Click Run Report to run your report and verify the content. The report output appears in IBM Cognos Viewer.
Tip: To return to Report Studio, close the IBM Cognos Viewer Web browser.

7. Insert another column in the report:
a. In the Source pane, expand Sales, Time, and Time.
b. Drag Year to the column after the Reason description column.

8. Insert a chart in the report:
a. In the Source pane, click the Toolbox tab.
b. Drag the Chart object below the crosstab.
c. When the Insert Chart window opens, click the Column chart type.
d. Select Fill with data and click OK. The data from the crosstab is automatically added to the chart.
e. Click the chart to select it.
f. In the Properties pane, underData properties, select the Query property. Select Query1 from the list. Tip: When you change the Query property to the query that you used for the crosstab, it becomes easier to find and reuse the same data items for the chart.

9. Create a filter to exclude the Wrong product ordered return reason from the crosstab:
a. In the crosstab, click the Reason description column heading.
b. On the toolbar, click the arrow next to the Filter icon, and click Create Custom Filter.
c. Under Condition, select Do NOT show the following values.
d. Under Values, select Wrong product ordered and move it to the Selected values list.
e. Click OK.

10. Create a prompt page for the order method to allow users to filter data in the report and retrieve data only for the order method they select:
a. Click the background of the work area to clear.
b. From the Tools menu, click Build Prompt Page.
c. Use Ctrl+click to select the Back and Next buttons, and the Double click to edit text prompt page title (that are automatically created) and delete them.
d. In the Source pane, click the Toolbox tab.
e. Drag the Value Prompt object into the prompt page. The Prompt Wizard - Value Prompt window opens.
f. Click Next.
g. Beside the Package item box, click the ellipsis (...) button.
h. When the Choose Package Item window opens, expand Sales and Marketing (analysis), Sales, and Order method.
i. Click the Order method dimension, and then click OK.
j. Click Next to accept the defaults, and click Finish.

11. Pause the pointer over the Page Explorer button on the Explorer bar. In Report Pages, click Page1 to return to the report page.
Tip: Click the Prompt Pages folder title to remove or rename a page, or to edit properties.

12. Add a title to the report:
a. Double-click the Double click to edit text title area, type Returns by OrderMethod, and click OK.

13. Save the report:
a. From the File menu, click Save As.
b. Name the report Returns by Order Method - Prompted Chart and click Save.

14. Run your report and verify the content:
a. Click the run report button.
b. In the Order method drop-down list, click E-mail and then click Finish. The report output appears in IBM Cognos Viewer.