18.7.2 Creating Data Model to Generate BIP Report

This section provides step-by-step procedure on creating data models using SQL query to generate a Business Intelligence Publisher report.

1. Login into the Oracle BIP URL using the corresponding credentials.
2. On the Home page, navigate to the New menu. Select the Data Model option from the drop down list.
3. On the Data Model page, under the Diagram tab, click the Add icon to add a new Data Set.
4. Select any one of the following options to create a Data model.

   Option 1

   1. Select SQL Query option from the drop down list. The New Data Set- SQL Query window is displayed.
   2. Enter the Data Set Name, Data Source, Type of SQL and the SQL Query and click OK. The list of available columns are displayed.

      Note:

      The Data Source field will have the value REP_CONN by default.

   Option 2

   1. Select Analysis option from the drop down list. The New Data Set- Analysis window is displayed.
   2. Enter the Data Set Name, Time Out (in seconds) and select the required Analysis using the Search icon, and click OK. The list of available columns are displayed.

   Option 3

   1. Select DV Data option from the drop down list. The New Data Set- DV Data window is displayed.
   2. Select the appropriate DV Data from the available list and click Next. The list of available columns for the corresponding DV Data are displayed.
   3. Select all the required DV Data columns and click Next.
   4. Click the Add icon to add the parameters and click Finish.
5. On the Data Model page, select Data tab to view the Data Set details.
   Users can view the Data Set in either Tree View or Table View.
6. Under Data tab, select the Save As Sample Data and click OK.
7. On the Data Model page, click Save icon to save the Data Model details.
   For more information on retrieving the BI Publisher report, see the Retrieving BI Publisher Export File from Object Storage section in the API Guide.