Collect data from Oracle Business Intelligence

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

It assumes that you have already established connectivity with your Oracle Business Intelligence server via the respective plugin connection profile.

1. Access New > Dataset > Create New

2. Dataset Editor > Info tab

Define the basics:

  1. Measured: select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Collecting: new Datasets are always disabled by default to make sure that you can take time to configure them properly before enabling. This setting is duplicated at the top of the screen
  3. Name: provide a unique name for your Dataset. Preferably, the Dataset name should explain what kind of data it contains
  4. Description: optionally, provide any additional information about your Dataset
  5. Category: specify the Category where you Dataset will be placed

Move to the Data tab to define the source of data and how often it should be updated.

3. Define the Settings for Data Collection

Data fetching can be configured using the following options:

  • Plugin query
  • Visual Editor

See details below.

3.1. Using the Plugin Command

  1. Data Source: select the connection profile you have created for Oracle Business Intelligence
  2. Data collection trigger: specify the Trigger that will be used to collect data for your Dataset
  3. Element: select an Oracle Business Intelligence Object that should serve as a basis of your Dataset
  4. Click [Manage Filters] to add Filters to your data
    • All added Filters will be displayed under Oracle Business Intelligence Filter Defaults below
    • Click the Edit (Pencil) icon to specify how many Values will be used for data filtering
  5. In the Command tab, input a Plugin Command (as exemplified above) listing all the data that needs to be fetched from Oracle Business Intelligence
  6. Validate your query

Note! 

Field and Filter Names must be enclosed in double quotes. 

3.1.1. Using the Visual Editor

The Oracle Business Intelligence Query Builder allows for data fetching without the need to learn the plugin syntax and helps avoiding typos/mistakes.

  1. Select the fields for your Dataset
  2. Optionally, add Derived fields and/or Count of duplicate rows

Save your settings. Plugin command validation will start automatically.

Note! 

  1. Derived fields can later be modified using the Edit (Gear) icon 
  2. Filters added as a field to the results set are distinguishable by a Filter (Funnel) icon
  3. Filters in Datasets build from OBIEE data are added as new columns. To avoid Column duplication, do not select the corresponding fields to be shown in the results set.

4. Plugin command will be validated and data collected on Save

  1. If the command is validated successfully, the Dataset columns and Data Preview are going to be shown below.
  2. At the upper right corner of the screen, click Enable & View.

5. Dataset will be displayed in Viewer

If any Filter has been applied, pre-filtered data will be displayed in Viewer.

In the Dataset Viewer:

  1. In the Results Section, you will see data with already applied External Filters
  2. You can further refine your data with Dataset's internal filtering options by applying Rules and Grouping Data: