1 / 8

QUERY STUDIO AD HOC ROSS REPORTS

QUERY STUDIO AD HOC ROSS REPORTS. COURSE PURPOSE. Instruct students in generating current year ad hoc ROSS reports using the Cognos Query Studio application. Focuses on understanding and using the ROSS Analytical Reports (AR) data package, as well as Cognos Query Studio functionality.

ahava
Download Presentation

QUERY STUDIO AD HOC ROSS REPORTS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. QUERY STUDIO AD HOC ROSS REPORTS

  2. COURSE PURPOSE • Instruct students in generating current year ad hoc ROSS reports using the Cognos Query Studio application. • Focuses on understanding and using the ROSS Analytical Reports (AR)data package, as well as Cognos Query Studio functionality.

  3. QUERY STUDIO AD HOCROSS REPORTS - OBJECTIVES Be able to: • Create an ad hoc list report. • Identify the ROSS-AR data package elements. • Explain the importance of correctly understanding, interpreting, and selecting data. • Add data to a report. • Save a report. • Run a report. • Modify the appearance of a report. • Print and save report results.

  4. QUERY STUDIO AD HOCROSS REPORTS - OBJECTIVES Be able to: • Manipulate values in a report. • Format report values. • Sort report values. • Group report values. • Calculate report values. • Summarize report values. • Filter report values. • Create and customize ad hoc crosstab reports. • Create a crosstab report. • Summarize report values. • Sort report values.

  5. QUERY STUDIO AD HOCROSS REPORTS - OBJECTIVES • Create and customize ad hoc crosstab reports (cont.) • Swap rows and columns. • Convert a crosstab report back to a list report. • Collapse and expand a group. • Create a custom group. • Create a report section. • Create a chart.

  6. QUERY STUDIO AD HOCROSS REPORTS – OBJECTIVES REVIEW Be able to: • Create an ad hoc list report. • Identify the ROSS-AR data package elements. • Explain the importance of correctly understanding, interpreting, and selecting data. • Add data to a report. • Save a report. • Run a report. • Modify the appearance of a report. • Print and save report results.

  7. QUERY STUDIO AD HOCROSS REPORTS - OBJECTIVES REVIEW Be able to: • Manipulate values in a report. • Format report values. • Sort report values. • Group report values. • Calculate report values. • Summarize report values. • Filter report values. • Create and customize ad hoc crosstab reports. • Create a crosstab report. • Summarize report values. • Sort report values.

  8. QUERY STUDIO AD HOCROSS REPORTS - OBJECTIVES REVIEW • Create and customize ad hoc crosstab reports (cont.) • Swap rows and columns. • Convert a crosstab report back to a list report • Collapse and expand a group. • Create a custom group. • Create a report section. • Create a chart.

More Related