What are the connection options available on OAC for Sharepoint or Onedrive. I want to automate the upload of the files to Sharepoint/Onedrive, which can be picked by OAC. What are the best solution options
Hi, thank you for your question and welcome to the community!
The connectors for Sharepoint and Onedrive will be available in the near future. This is being developed and planned as part of the product roadmap available in the community knowledge base.
Thanks for the update. What are the other options to automate file upload and refresh the reports?
You can refer to the Microsoft help on Automating File Uploads to Sharepoint using Power Automate.
Hi @User_X7U2V , do you mean automate file upload and refresh reports in OAC?
Do you mind if we take a step back to understand your situation/case and be able to answer based on that instead of guessing?
You have some OAC content, probably DV workbooks built on top of one or more dataset, right?
And now you would like to know how you can refresh the content of those dataset so that, when your users open the workbooks, they see fresh data and not the same old copy all the time?
What is your source?
Hi @Gianni Ceresa ; That is correct. Our data comes from multiple data sources - Oracle DB ( Onprem), ADW, etc. But we also have a good number of CSV/Excel as sources. Instead of the developer manually uploading/reloading these files into Datasets, I am looking at options to have the end user upload to a shared folder with OAC refreshing the data from there. I am ruling out OCI storage and custom ETL to load to tables etc for now. OAC to access CSV files in storage and report based on the latest data in CSV/Excel
This feature is still not available in FDI
Is there a timeline for this feature? Was hoping to see it this year with the collaboration between MS and Oracle
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
