Enable Descriptive Flexfields for Oracle Business Intelligence

You can use descriptive flexfields in Oracle Transactional Business Intelligence. If you haven't already created flexfield segments, you first create them, then deploy them, and then import them into Oracle Transactional Business Intelligence. After you import your descriptive flexfields into Transactional Business Intelligence, you can

To use descriptive flexfields with Transactional Business Intelligence:

  • Define flexfield segments.

  • Run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process.

  • Create an analysis in Transactional Business Intelligence.

Define Flexfield Segments

To define flexfield segments:

  1. Navigate to the Setup and Maintenance work area.

  2. Open the Manage Descriptive Flexfields task.

  3. Search for and select the flexfield code that you want to use, and edit it.

  4. Select the BI Enabled option.

  5. Save the flexfield and deploy it.

Run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence Process

To run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process:

  1. Navigate to the Scheduled Processes page.

  2. In the Search Results region of the Overview page, click Schedule New Process.

  3. In the Schedule New Process window, click the Search: Name arrow in the Name field, and click the Search link at the bottom of the list.

  4. In the Search and Select: Name window, enter Import Oracle Fusion Data Extensions for Transactional Business Intelligence in the Name field.

  5. Select the row for Import Oracle Fusion Data Extensions for Transactional Business Intelligence, and click OK.

  6. In the Schedule New Process window, click OK.

  7. In the Process Details window, click Submit.

  8. In the Confirmation window, click OK.

  9. In the Process Details window, click Close.

  10. On the Scheduled Processes, Overview page, enter Import Oracle Fusion Data Extensions for Transactional Business Intelligence in the Name field.

  11. Click Search to see the status of the job.

    Note: The job may take several minutes, depending on your system.

Create an Analysis in Transactional Business Intelligence

After you have successfully run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process:

  1. In the Navigator menu under Tools, select Reports and Analytics.

  2. In the Reports and Analytics work area, click Create and select Analysis.

  3. In the Select Subject Area window, find and select the subject area that contains the flexfield that you deployed and imported.