Enabling Descriptive Flexfields in Oracle Fusion Analytics Warehouse

October 28, 2022 | 6 minute read
Krishna Prasad Kotti
Senior Member of Technical Staff
Krithika Raghavan
Director, Oracle Analytics
Text Size 100%:

Oracle Fusion Analytics Warehouse (FAW) is a family of prebuilt, cloud native analytics applications for Oracle Fusion Cloud Applications that provide line-of-business users with ready-to-use insights to improve decision-making. This article relates to Fusion Analytics Warehouse Release 22R3 and outlines the steps required in Oracle Fusion Cloud Applications to enable descriptive flexfields.

A flexfield is a set of placeholder fields associated with business objects and placed on application pages to contain additional data. You can use descriptive flexfields to capture additional information about items beyond what's provided by the predefined set of operational attributes. All the business object entities that you can use in the application are enabled for descriptive flexfields in Oracle Fusion Cloud Applications. However, configuring descriptive flexfields is an optional task. It’s important to decide on the flexfield structure that fits your organization. You use descriptive flexfields to add attributes to business object entities and to define validation for them.­­­­­ Once descriptive flexfields are enabled, it’s essential to make them available for reporting.

You complete three major activities to report on descriptive flexfields in Fusion Analytics Warehouse.

  1. Enable descriptive flexfields for business intelligence
  2. Determine attribute names
  3. Enable attributes in Fusion Analytics Warehouse

Enable descriptive flexfields for business intelligence

  1. Log in to Fusion Applications.
  2. Navigate to Set up and Maintenance.
  3. Click Search and navigate to Manage Descriptive Flexfields.
    Manage Descriptive Flexfields
  4. Click Edit.
    Edit DFF
  5. Ensure that BI Enabled is checked.
    DFF BI Enabled
  6. Click Manage Contexts.
    Manage Context
  7. Click Search and Edit Context.
    Edit Context

     
  8. In Context Sensitive Segments, click Edit.
    Edit Context Segments
  9. Ensure that BI Enabled is checked under Business Intelligence.
    BI Enabled
  10. Save your changes and repeat these steps for all Context Sensitive Segments and for all Segments.
  11. Click Deploy Flexfield.
    Deploy Flexfileds 01
    Deploy Flexfields 02
    Deploy Flexfields 03

The flexfields should be deployed without any errors.

Determine attribute names

  1. Log in to Oracle Transactional Business Intelligence (OTBI) and confirm that flexfields are available in the subject areas.
  2. Create a report with all these flexfields and capture the OTBI logs.
    DFF OTBI Report 01
  3. Based on the logs, find the attribute names.
    OTBI Logs

You’ll use these attributes in the descriptive flexfield mapper for Fusion Analytics Warehouse.

If you do not see the DFF columns in OTBI then run the "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" ESS job in Fusion.

 

Enable attributes in Fusion Analytics Warehouse

  1. Log in to Fusion Analytics Warehouse.
  2. Navigate to Console.
  3. Click Data Configuration.
    If you configure more than one source in Fusion Analytics Warehouse, then make sure that the drop-down list at the top shows Fusion and click Custom Data Applicatons.

    Custom Apps
  4. Edit the Custom Apps and Select Descriptive Flex Fields.
    FAW Edit DFF
  5. Select the descriptive flexfield, and click Edit.
    FAW Edit DFF Mapper02
  6. Select the Columns based on the attribute names that you decided on using the OTBI query.
    FAW Edit DFF Mapper03
  7. Click Save.
    FAW DDF Mapper01
  8. Click Generate.
    FAW Generate DFF Mapper
    FAW DFF Mapper Schedule

 

When the Job is completed, you see the descriptive flexfield in the subject area.

 

DFF Mapper Schedule Complete

DFF Subject Area 01

DFF Subject Area 02

You can now use the descriptive flexfields to extend your data for detailed and varied analytics.

For more details on Data augmentation, see Fusion Analytics Warehouse Documentation.

Schedule a meeting today to talk to the Oracle Analytics product team and learn more about how you can deploy Oracle Fusion Analytics Warehouse.

Krishna Prasad Kotti

Senior Member of Technical Staff

Krithika Raghavan

Director, Oracle Analytics


Previous Post

Introducing Project Analytics in Oracle Fusion ERP Analytics

Steffy Jenson | 6 min read

Next Post


Concert Venue Ticket Pricing Analytics - Part 1: Grid Heat Maps, Bars, and Radar Bars

Jamie Anderson | 7 min read