Oracle FDI BI publisher data Augmentation

Han Xi Zhao

Hi,

we need to add data from a BI Publisher report into Oracle FDI. We managed to add the BI Publisher connector, but we don’t understand how to join the standard Oracle FDI subject areas fields with the BI Publisher report.

Thanks.

Silvio Garber-Oracle

Once your BIP data is in ADW you can use it to create a Data Augmentation, which is typically an extension to an existing table. Then you can expose these new columns to a subject area using Semantic Model Extensions.
You may want to check the videos at FDI Implementers Series - Oracle Video Hub .

RVohra

@Han Xi Zhao , Welcome to the Oracle Analytics.

It is possible for Service Administrator. As a service administrator, you can use the Fusion Data Intelligence extract service to acquire data from the Analytics Publisher reports and use it to create data augmentations for various use cases.

Currently, the Oracle BI Publisher connector only supports:

• The Analytics Publisher in Oracle Fusion Cloud Applications for data augmentation.
• Only those reports that complete within the Analytics Publisher report execution timeout limit that's typically 300 seconds.
• The connector only supports CSV file formats with a comma-separated delimiter. Other delimiters are not currently supported.

The Oracle BI Publisher connector workflow must observe the security rules of Oracle Fusion Cloud Applications. You must ensure that the password rotation and update are done on time before executing the Oracle BI Publisher connector pipeline. Otherwise, those pipeline refreshes hang and eventually get deleted, and the data source is disabled until you update the password and resubmit the refresh request.

Ensure that Oracle BI Publisher is enabled on the Enable Features page prior to creating this connection.

Hope it helps!