We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Load Data from Oracle BI Publisher into Fusion Analytics Warehouse(FAW) - Preview Feature
Hi All,
Recently Oracle release a feature to bring additional data from HCM cloud application using following feature. I am trying to implement the same and as per the steps provided in below documentation, I have created a sample BIP report which generate the output in CSV format.
Load Data from Oracle BI Publisher into Fusion Analytics Warehouse - Preview Feature
As mentioned I have created a BI publisher connection and gave report path under list of reports column as mentioned in following format:
Suggested Report Path :https://</a><server:port>/xmlpserver/<ReportDirectory>/<ReportName>.xdo.
Given report path : https://<<HostName.praclecloud.com>/xmlpserver/Custom/SampleFAWHCMPOC_Report.xdo
when I am testing the connection it is failing and showing below error:
Please suggest your inputs.
Best Answer
-
Hi ,
unfortunately documentation is not correct. here we just need to mention the report path. I was able to establish the connection.
Thanks,
Ankur
0
Answers
-
Hi Ankur,
This message indicates it cannot access the path. The path examples are here: https://docs.oracle.com/en/cloud/saas/analytics/23r3/fawag/managing-data-connections.html#GUID-5D394FD0-F9D6-48D0-B9F0-0F8861530CEA
1 -
I was able to complete without error. I would change your path to Custom/Ankur/SampleFAWHCMPOC_Report.xdo No need for the URL or xmlpserver
1 -
Yes I was able to resolved it.
Regards,
Ankur
0 -
Did you have any issues with setting the Pipeline Refresh? I am unable to get it working.
0 -
I am yet to start on this.
0 -
Hi @Ankur Jain--Oracle, @SharonAtGorilla , @JohnW-Oracle
I am trying to do this… but connection is not setting up sucessfully :(
could you help me ?
0 -
0 -
Solved!
This is what worked for me -
Entire report path with report name in list of reports. and only report path in reports configuration
0
