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 Oracle Analytics catalog and select Edit. Or:
   1. In the catalog, find the report to generate sample data for and select Edit.
   2. Select the data model name in the report editor.
2. In the data model editor, select View Data.
3. Enter values for any required parameters, select the number of rows to return, and select View.
4. To save the sample data to the data model, select Save As Sample Data.
5. If you're designing an .rtf template, select 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 Oracle Analytics catalog.
2. Select Open to run the report in the report viewer with the default parameters.
3. On the Actions menu, select Export, then select 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 Oracle Analytics catalog.
2. Select 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. Select Submit.
6. Open the Report Job History page.
7. On the global header, select Open, then select Report Job History.
8. Select your report job name in the Job Histories table.
9. On the details page, under Output and Delivery, select XML Data Download.