Create a Data Set Using a View Object

Publisher enables you to connect to your custom applications built with Oracle Application Development Framework and use view objects in your applications as data sources for reports.

Performance of the query execution is better as the SQL is executed directly against the database.

Before you can create an Publisher data model using a view object, you must first create the view object in your application.

Click the New Data Set toolbar button and select View Object.
In the New Data Set - View Object dialog, enter a name for this data set.
Select the Data Source from the list. The data sources that you defined in the providers.xml file display.
Do one of the following:
- Select Yes for Execute as SQL to extract the SQL query form the View Object and execute it on the Oracle Analytics Server domain.
- Select No to execute the view object on the Oracle Applications domain through the ADF layer. The XML data is then streamed to the Oracle Analytics Server domain in chunks. This method results in poorer performance, but enables execution on the Applications domain. You can invoke some service interface layers to allow custom data manipulation.
Enter the fully qualified name of the application module, for example, example.apps.pa.entity.applicationModule.AppModuleAM.
Click Load View Objects.

Publisher calls the application module to load the view object list.
Select the View Object.

Any bind variables defined are retrieved.
Create a parameter to map to this bind variable.
Click OK to save your data set.

Additional Notes on View Object Data Sets

To structure data based on view object data sets, the group breaks, data links and group-level functions aren't supported.

You can set the Value if Null property of the elements. See Set Element Properties.