I know there is an REST endpoint to Reload the data for an existing dataset. Is there an API or any other way to create a new dataset too?
There is an API, because that's what DV does use: an API. It simply isn't documented... Therefore it depends how badly you need/want it ;-)
Open your browser developer tool, looks at the network calls the UI generate and you easily see how you can automate and script things.
Documented? No. Supported? Not officially, but that's how the UI does it, therefore implicitly it is supported.
You just have to evaluate if the efforts and risks are worth the benefits you get from it.
Hi ,
Reload data for a dataset (Preview) is an preview feature. As per documentation , we don't have any API call for RESET dataset creation.
How To Refresh Data Sets Automatically in Oracle Analytics (Doc ID 2578915.1)
You can submit can Idea's Lab Request -
How to Submit an Enhancement Request for Your Oracle Cloud Application through Idea Labs on Cloud Customer Connect (Doc ID 2254478.1)
Any Other comments are welcome
Regards,
Arjun
@DeepaliG-Oracle see: Connect to Data from REST Endpoints (Preview)
It needs to be enabled by an Admin in the console --> system settings
@SteveF-Oracle I guess, you didn’t get the essence of this query (I judge by your recommendation).
@DeepaliG-Oracle There are already plenty of Ideas for the same (rich Rest API, allowing manipulation of different DV objects, including data sets) see for example:
or (which is wrongly set in Delivered status):
So you don’t have to create new one, you can vote for one of them.
As @Gianni Ceresa pointed, there is internal , very rich (in opposite to one which is public in OAC) REST API for DV used internally in product, the only drawback is that Oracle is not making it public, so the usage is not supported and is also not documented.
For this public REST API - this is according to me most overlooked area , new extensions are created very slowly, and the worst thing for us OAS customers is, that so far it is not even available in OAS (just OAC).
If you see the FY24 Roadmap link posted by Ben, you will find the following features in the upcoming release :
OAC Catalog API
OAC Connections API
Not sure if OAC Connections API will also include enriched APIs for Dataset Management, maybe PMs in this forum can comment on that.
Thanks
Gayathri
@Michal Zima - Yes, I got the gist. This is an Oracle employee that had already posted to an internal channel (multiple requirement), appreciate the catch. I can see how my comment could be confusing in this context. ;-)
Enjoy your day, and thanks for your helpful comments in the community!
@Bret Grinslade - Oracle Analytics-Oracle - Let us know if you have any further public comments about the roadmap.
@SteveF-Oracle . Got it, thanks for explaining me the internals.
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Hello Team, While building a Pivot Table view for my report, 2 out of the 4 metric columns contain completely null values. I'm looking for a way to automatically exclude or hide metric columns whenever they are entirely null or zero. Could you please advise on how to achieve this? Thanks.
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
