You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to insert details into report_log table from Oracle cloud analytics publisher

Summary:

Project was on on-prem earlier, now it is moving to OTM cloud. BIP reports were implemented in on-prem version as well.

Users will run and schedule the reports in OTM. All the reports will be configured in Oracle analytics publisher(data model,layout)
We have a requirement to insert the details of a report into OTM report_log and report_log_parameter database tables , after the report run has completed.
In on-prem we did it in database pl-sql packages. But what would be the right way to do this in cloud BIP? Or is there a way in OTM itself to ensure that every custom report whenever it runs, it automatically stores details in those database tables when enabled?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!