If you are looking to monitor just the agents, usage tracking is still the best possible option until our publicly documented APIs expand scope and become available.

For OAC Agents, you can use Usage Tracking to find the details of a specific agent, error message, etc. For BI Publisher catalog objects auditing check the following doc : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/audit-data-publisher-catalog-objects.html#GUID-6E05FC42-D2CF-4658-B9A1-595968CC8FA6

You can use Externalize connection and define this connection in DV instead of populating the connection pool dsn/credentials values in RPD. As long as source and target use the same connection name, you will not have to do any re-work on the rpd.

So is your rpd connection pool referencing an external connection(as in connection defined in console >connections)? Is this connection name the same between source and target snapshots?

Please note that this thread is more than 2 years old, so suggest to post your question in a new post. As noted by Alan, BVT is not supported with OAS. So any custom solution will not be supported even if it works with workarounds, etc. Also here is the Idea Lab request for this ask where you can upvote/add your comments…

You can also explore the Audit log capability available as part of OCI Logging for OAC. Doc here : Monitor Usage and Diagnostic Logs Also look into the DV Governance plugin available here :https://www.oracle.com/business-analytics/data-visualization/extensions/

This issue seems to happen if you have java access bridge enabled in your windows machine. To disable java access you need full version of JRE. You can download latest JRE from OTN (I see that the link given above to a km does not work but you don't need km doc to download JRE). If you already have JRE installed on this…

Currently the plugin is the only way to get the information you are looking for. Probably dataset APIs will be enhanced as part of future roadmap to be more robust, but as of now this is not there and analytics plugin Philippe mentioned provides the workable solution for this requirement.

Hi Using WITH clause in SQL syntax for dataset is not supported. This is because OAC wraps the user's SQL query inside another query to limit the number of rows fetched from the DB, but the Oracle DB does not support WITH clauses nested inside of other select statements( It will give error "ORA-32034: unsupported use of…

In addition to above comments, you can also check with sales on getting guidance on appropriate shape for your instance based on projected usage. Since we do not have the CPU/memory consumption metrics, the way to look at existing usage would be to check the query capacity metrics in OCI console. If you are consistently…

Hi Wayne You can check the following blog posts which provides example using python or oci functions to export the json data exported from OCI Logs : https://blogs.oracle.com/cloud-infrastructure/post/exporting-oci-audit-logs-in-csv-format-for-desired-time-period…

Hi Wayne You can check the following blog posts which provides example using python or oci functions to export the json data exported from OCI Logs : https://blogs.oracle.com/cloud-infrastructure/post/exporting-oci-audit-logs-in-csv-format-for-desired-time-period Thanks Gayathri

Just to note that the KM doc you referenced here was created for 'Primavera Cloud Services' product and is not applicable to Oracle Analytics Cloud. For OAC we cannot increase any configured limit via backend. You have to apply necessary filters, reduce columns/cells to be within the documented export limit based on your…

Hi This seems a question for fusion team, will be better to post here : https://community.oracle.com/products/oracleanalytics/categories/otbi Moderators, if possible kindly move this post to fusion. Thanks Gayathri

Hi This has been identified as a known issue which is fixed in next release of OAC. Thanks Gayathri

Another suggestion would be try this as formula in DV by creating Calculated Item. I just tried a simple test case with similar formula and DV showed proper results.

Hi Please check session.log when you execute the dashboard after seeding cache using both methods and verify if the one taking longer is producing a cache hit or is it sending to database. Check Table 5-3 Factors That Determine Whether Cache Is Hit in the following Cache hit section of doc :…

Are you able to access /analytics endpoint (Classic Home)? If so suggest you attempt login to analytics -> my account -> Application Roles and validate the Application Roles assigned to user01.

@Manu R-Oracle Please note that this is a public forum, so please do not share CI/PI info. Since you are oracle employee, you can always use our internal slack channels for further assistance OR you can create SR with Support so we can assist you further. Thanks Gayathri

Also note that if you have OBIEE/OAS/OAC applications connecting to Essbase, there is a way to define SSO connection from BI to Essbase which uses LoginAs command. So depending on how the connection to essbase is defined, loginas could be reported in audit logs for queries coming from BI to Essbase.