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.
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 .
@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 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!
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
How to show amount columns with currency symbol and format in AI Agent response. Provided sample in supplement instruction but it is not displaying based on format
After the recent Oracle FDI/OAC release updates, both our PROD and DEV environments no longer display the Data | Visualize | Present tabs at the top of the workbook.Previously, I used the Present tab to: Hide or show specific canvases/visualizations. Hide filters used in the workbook. With the new workbook interface, I…
We are trying to clarify the 2 data sets that go into the oracle-delivered "Headcount Turnover" measure. This measure is found in FDI, in "HCM - Workforce Core"."Facts - Workforce Headcount" subject area We have our own internal calculation, which is a few percentage points different than this measure, which is why we are…
My data: My Calculation - above in the last column you can see it works great: So why the heck my table goes blank for every value in Month End Date filter?
Dear Experts, We are trying to add security steps to our new implementation but the option that is mentioned in oracle documentation and also seen on other existing implementations is not available in our instance. The Navigation is FDI Console> Semantic Model Extensions> Security Configurations> Data Security Step.…
