In addition to what was mentioned above, for the problematic user login classic home, click on User Profile icon and My Account->Application Roles and verify the Roles assigned. As Gianni mentioned for DV access you can make the customer role or group, a member of a default application role like DVConsumer DVContentAuthor…

Here is an old KM doc from 11g days- 1569615.1 Presentation Catalog Permission Behavior When Same EBS User Logs Into OBIEE Using Different Responsibilities Back And Forth , where suggestion was to disable ACL cache settings in instanceconfig.xml file, not sure if this is still relevant for OAS. Also for OAS I believe the…

Hi Please note the following Idea Lab request for this feature, kindly up-vote this idea and add your comments :https://community.oracle.com/products/oracleanalytics/discussion/9993/display-alerts-in-banner-for-important-user-notifications Thank you Gayathri

Hi Please look into Audit Log capability via OCI Logging : Monitor Usage and Diagnostic Logs Audit logs lets captures the following Log activity in Oracle Analytics Cloud for catalog objects : Catalog objects: Create, update, delete, and permission change operations on all catalog objects, such as classic analyses,…

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.