Report Studio

Cognos 10.1.1 is a Cognos application that is used as a module in the Sterling Selling and Fulfillment Foundation to produce and maintain user reports for Web-based distribution, scheduling, and maintenance. This tool produces reports in 25 languages and seven formats.

Cognos 10.1.1 has two areas for creating reports, Report Studio and Query Studio. Query Studio is used for creating ad hoc reports that are used one time, cannot be maintained and have no shelf life. Report Studio is used for reports that remain in the system, is scheduled and routed, and are customizable and reusable. This chapter contains information for users of Report Studio. Query Studio is documented in the Cognos 10.1.1 User Guide.

Selling and Fulfillment Foundation has provided fifteen reports for Sterling Warehouse Management System that can be used "as is". These reports are used as starter templates for developers fluent in creating and maintaining reports using Cognos 10.1.1.

This topic provides basic information for using Report Studio, utilizing the Sterling Warehouse Management System reports and customizing those reports for your application. Use the documentation set provided on the Cognos CD-ROM or at the Cognos Web site at http://www.cognos.comwww.cognos.com for additional information about creating and maintaining reports using the Cognos 10.1.1 applications, including Report Studio, Query Studio, and Framework Manager.

Report Studio is used for creating, maintaining, scheduling, and routing reports detailing every aspect of the Warehouse Management System. Specifications for a report are created in Report Studio or Query Studio. When you need to edit saved reports you must use Report Studio as Query Studio is not used for editing after a report has been saved.

Report specifications are viewed from the Tools menu by selecting Show Specifications. These specifications are an XML document. When you run a report, information from the report specifications, the model metadata, and report properties are combined. These three items define the content, format and appearance of the resulting report.

Data displayed in a report is defined by the built in query the report runs. Report Studio maintains a default query for each stored report. Additional data items are combined with the default query. You can create additional queries in single report. Calculations and Summaries can also be added to your report.

The authoring components of Query Studio and Report Studio, produce the required specifications for a report. However, additional information is obtained from other Cognos 10.1.1 resources running in the background. The main content of the report is generated from several data sources through the published model. Additional information comes form calculations and background reports. Cognos 10.1.1 also contributes a small amount of information for reports.

Report output is produced when you run a report the first time. The results are stored in Cognos 10.1.1. This version of the report is used to create similar reports multiple formats. Available formats include PDF, XML, HTML, XHTML, XLS (Excel) or CSV. Report users with proper authority can create, save, and schedule their own views of a report.