Create Dataset from Oracle Business Intelligence

This article details how to create a Dataset populated with data sourced from Oracle Business Intelligence.

PREREQUISITE:

Established connectivity to the Oracle Business Intelligence server

1. Create New Dataset

Access New > Dataset > Create New

Enter the basics:

  1. Select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Specify if Dataset should be searchable
  3. Input a descriptive phrase in Name
  4. Specify Category to place the Dataset

Proceed to Data tab to define details

2. Define the Settings for Data Collection

  1. Select the OBIEE Data Source
  2. Specify Data collection trigger that will be used to collect data for Dataset
  3. Choose the OBIEE View that should serve as a basis for Dataset
  4. Input Plugin command listing all the data you would like to fetch from OBIEE
    • Build your query in MIQL OR
    • Use Visual Editor. This will automatically validate the command
  5. [Validate]
    • If the statement is valid, the Validation Rows Preview section pops up at the bottom of the screen
  6. [Enable & View] to proceed to Dataset Viewer

NOTE 

Field and Filter Names must be enclosed in double quotes.