Typical Workflow to Model Data for Pixel-Perfect Reports

A data model used for pixel-perfect reports can be simple with one dataset retrieved from a single data source (for example, the data returned from the columns in the employees table) or can be complex with parameters, triggers, and bursting definitions and using multiple datasets.

Task User More Information

Launch the data model editor.

Report Data Modeler

Launch the Data Model Editor

Set properties for the data model. (Optional)

Report Data Modeler

Data Model Properties

Create the datasets for the data model.

Report Data Modeler

Create Datasets

Define the data output structure. (Optional)

Report Data Modeler

Structure Data

Define the parameters to pass to the query, and define lists of values for users to select parameter values. (Optional)

Report Data Modeler

Add Parameters and Lists of Values

Define Event Triggers. (Optional)

Report Data Modeler

About Triggers

(Fusion Applications Suite only) Define Flexfields. (Optional)

Report Data Modeler

Add Flexfields

Test your data model and add sample data.

Report Data Modeler

Test Data Models and Generate Sample Data

Add a bursting definition. (Optional)

Report Data Modeler

Add Bursting Definitions

Map Custom Metadata for documents to be delivered to Web Content Servers (Optional)

Report Data Modeler

Add Custom Metadata for Oracle WebCenter Content Server