Generating a Sample Report

Depending on the type of report layout changes you're making, sample data can be required or optional. You generate sample data, and then load it for use with your layout so that you can map data fields to layout components. For example, for the Start Date table column in your layout, you can set it so that the data displayed in that column comes from the Start Date field in the sample data.

You can generate sample data from the:

  • Report data model
  • Report viewer
  • Scheduler

Generating Sample Data from the Data Model

Follow these steps:

  1. Select your data model in the OAS catalog and click Edit. Alternatively:
    1. In the catalog, find the report to generate sample data for and click Edit.
    2. Click the data model name in the report editor.
  2. In the data model editor, click View Data.
  3. Enter values for any required parameters, select the number of rows to return, and click View.
  4. To save the sample data to the data model, click Save As Sample Data.
  5. If you're designing an .rtf template, click Export to save the file locally.
  6. Save the data model.

Saving Sample Data from the Report Viewer

For reports that are enabled for online viewing, you can save sample data from the report viewer:

  1. Select the report in the OAS catalog.
  2. Click Open to run the report in the report viewer with the default parameters.
  3. On the Actions menu, click Export, then click Data.
  4. Save the data file.

Saving Sample Data from the Scheduler

For reports that are enabled for scheduling (not necessarily as a scheduled process), you can save sample data from the scheduler:

  1. Select the report in the OAS catalog.
  2. Click Schedule.
  3. On the General tab, enter values for any report parameters.
  4. On the Output tab, ensure that Save Data for Republishing is selected.
  5. Click Submit.
  6. Open the Report Job History page.
  7. On the global header, click Open, then click Report Job History.
  8. Select your report job name in the Job Histories table.
  9. On the details page, under Output and Delivery, click XML Data Download.