Considerations for Enabling Extensible Flexfield Segments for Business Intelligence

An extensible flexfield that's registered in the database as enabled for Oracle Transactional Business Intelligence (OTBI) includes a BI Enabled setting for each of its segment instances. When a segment instance is BI-enabled, it's available for use in OTBI.

The following aspects are important in understanding BI-enabled extensible flexfield segments.

Flattening business components to use BI-enabled segments in Oracle BI
Mapping attributes of flattened business components to logical objects in OTBI

After you deploy a business intelligence-enabled flexfield, use the Import Oracle Data Extensions for OTBI process to import the flexfield changes into the Oracle Transactional Business Intelligence repository. Users can make use of the newly-generated attributes in business intelligence applications. For information about logical objects and import, see the Creating and Administering Analytics and Reports guide for your products.

Flattening

When you deploy a business intelligence-enabled extensible flexfield, the deployment process generates an additional set of flattened business components for use in business intelligence. The flattened business components include attributes for business intelligence-enabled segment instances only.

If you assigned a label to a segment, the flattened components include a single attribute representing all segment instances with that label. If you didn't assign a label, the flattened components include a discrete attribute for each BI-enabled segment instance in each structure.

Importing to Oracle Transactional Business Intelligence Repository

After you deploy a business intelligence-enabled flexfield, import the flexfield changes into the Oracle Transactional Business Intelligence repository to make use of the newly flattened business components in business intelligence and then propagate the flexfield object changes. When you import the metadata into the Oracle Transactional Business Intelligence repository, you must do so as the FUSION_APPS_BI_APPID user. To import flexfield changes into the Oracle Business Intelligence repository in Oracle Cloud implementations, run the Import Oracle Data Extensions for Transactional Business Intelligence process. For information about logical objects and import, see the Creating and Administering Analytics and Reports guide for your products.

Tip:

When you import a flexfield into the Oracle Transactional Business Intelligence repository, you see both <name>_ and <name>_c attributes for each segment, along with some other optional attributes. The <name>_ attribute contains the value. The <name>_c attribute contains the code of the value set that the value comes from, and is used for linking to the value dimension. You must import both attributes.