Hi,
I am trying to pull/use OTBI subject areas in Oracle FDI. Is there a way to do so?
Thanks,
Ruvina
@Ruvina Khan As mentioned by @Sumanth V -Oracle You can create a Data Connection in the FDI integrated OAC to the Oracle Application connector. Once done, you can create a dataset based on the OTBI Connection.
The OTBI Subject areas will be visible post that.
Hi @Ruvina Khan,
Can you please provide some more details regarding your requirement, it will be helpful for fellow community members to understand and offering potential solution.
i.e. Are you looking to embed OTBI SAs within FDI or trying to combine OTBI SAs with FDI, etc.
Also please take a look into the following document which might be helpful.
https://blogs.oracle.com/analytics/post/how-otbi-and-faw-complement-each-other
Thank you.
From Administration console for Fusion Data Intelligence page, go to Data Configuration —> Data Augmentation —> Select Create Option —> Choose Augmentation —> Follow steps 1 to 6 to create the Data set in FDI using OTBI Subject area/PVOS
Hope this helps..
Hi @Bhaskar Konar,
I am trying to embed the OBTI subject area in FDI.
@Ruvina Khan - Kindly review usage of Oracle Application Connector to connect to Fusion Application. This will help you create datasets based on OTBI subject areas.
Review the document below for more details:
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-fusion-cloud-applications-suite.html#GUID-FDC9B8BD-4CC4-4AA2-8C02-1078E4FA32A2
OAC: How to Connect to Oracle Fusion HCM-OTBI from OAC DV Dataset with SSO. (Doc ID 2607450.1)
Hope this helps!
@Ashish-Oracle
When I try this, I get the following error:
Failed to save connection "there was an unexpected error while processing this request.
I am using the Local credentials and I tried All three options for Authentication.
Host:
https://XXXX.fa.ocs.oraclecloud.com/analytics
Thanks.
I createdf an OTBI Finance Period Status Close report and would like to generate the POV log for FDI link. Please advise how to do it. I heard under our username, we should see administrator. Is there a role needed? Appreciate your advise.
By above process we can connect OTBI SA and create the New data set based on selected columns or Folders. But we can not bring entire SA as-is into FDI. In my case we required Entire Subject area into FDI. Can you please help us how to do it.
Thanks
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
How to Inject external data (Business central data) into Oracle Autonomous lakehouse via SFTP connector in FDI?
OOTB subject area fields are not available in DEV and PROD. Existing workbooks display "Error Loading Data" and report that standard fields are cannot be found. Local Subject Areas also display "Schema listing not available". The issue appears to affect the FDI semantic layer/metadata across environments. Can anyone facing…
I’m currently facing an issue with the Absence data in FDI. For example, in the screenshot, the Approved Absence measure is showing 1, while the correct value in Fusion 1,560. A few points: This is the standard/prebuilt dashboard; no customizations were made. There is no date filter applied. The FDI refresh runs daily, so…
Report 1 :We do have FRS report with 7 to 8 columns.HTML veiw of the report showing extra space .how to fit the output to the report .There should not be space in the html report.Attaching the report output. Report 1 output : Report2 : We do have an FRS Report where one connection has all ledgers except CSG IND STAT…