Add pages to a new or existing report that contain different content to create a multiple-page report.In this topic, you learn how to create a multiple-page report that shows two sales performance reports.
It should take 10 minutes to complete this topic, and the two report pages will look like this.
In the below example we are taking region, retailer, planned revenue, revenue and gross profit as the data items for the list report and also chart report.
Steps to create a Mutlipage report in Cognos:
1. Create a list report that uses the sample package named GO Data Warehouse (query). If you want to know how to create a list report, you can view the tutorial on list report here.
2. Add these data items to the list report list and create a default list report.
● Region (in Retailer site)
● Retailer country (in Retailer site)
● Planned revenue (in Sales fact)
● Revenue (in Sales fact)
● Gross profit (in Sales fact)
3. Group the Region column to make the report easier to read. You can do this by clicking on the region column and selecting the group by from the aggregation functions. You can also do this by simply dragging the region column name region under the grouping and sorting properties available in the left side properties pane.
4. Change the blue text placeholder to "Performance by Region".
5. Add a page by simply dragging and dropping a page to a page explorer window.
6. Now, Add a 3-D column chart to the new page as a new query.
7. Add the following data items to the chart:
● Revenue (in Sales fact) to the Default measure (y-axis) drop zone
● Order method (in Order method) to the Category (y-axis) drop zone
● Region (in Retailer site) to the Series drop zone
The corresponding chart looks like the below after running.
Tip: Use the Source tab in the Insertable Objects pane.
8. Run the report and click Page down to see the two different pages.
That's it, you are done with adding 2 pages to a report. If you like my tutorials and want to be updated with all the new posts, you can simply sucribe to this site either by mail or rss using the option on the right sidebar.
2 comments:
I like this. How would create in the header to show both the pages as tabs on the same report? In other words one reports with different views in a tab format..
could you please provide us the information, how to display one page from the multiple pages based on the prompt selection.
Post a Comment