Creating a Report Template

  To create a report template:

1. Create a query definition for the report.

   1. On the Setup tab, under Reports, select Query Definition.

   2. In Query Definition, click Add.

   3. In Name, enter the name of the query definition.

      Oracle recommends that you assign a name that corresponds to the report definition in which the SQL is embedded.

   4. In Select Clause, specify the SQL Select clause used to query the database and return the data that corresponds to your selected criteria.

   5. In Where Clause, specify the SQL Where clause used to restrict the data that is returned to only the specific criteria that you specify.

   6. In Group by/Order by Clause, specify the Group by or Order by clause.

      The ORDER BY clause sorts the records in the result set. The ORDER BY clause can be used only in SQL SELECT statements.

      The GROUP BY clause fetches data across multiple records and returns the results grouped by one or more columns.

   7. Click Validate Query.

      If the query definition is validated, FDMEE returns the message: “Query validation successful.”

      If the query definition is not validated, FDMEE indicates that an error was found in the SQL. You must fix the error before validating the query again.

   8. Click Save.

2. Click Generate XML.

3. Create the report template.

   1. Install the XML Publisher Desktop.

      See the Report Designer's Guide for Oracle Business Intelligence Publisher.

   2. Load the XML created in step 2.

      Reference the template builder tutorial as needed.

   3. Save the template, and then upload it to the server.

4. Create report definition with group, query and template.