did you install DVML?

It should create the table on the fly. Does the ID have correct permissions.

Can Tableau connect to data sources via JDBC? If so then create the JDBC Connection to the Presentation layer as the documentation shows in the link shows.

Tableau can connect via JDBC and the OAC RPD can be accessed via JDBC Connection https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/query-data-models-remotely-using-jdbc.html

@SteveF-Oracle that link was very helpful. If I had read the docks closer i would have found this https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/view-audit-data-publisher-catalog-objects.html#GUID-6E05FC42-D2CF-4658-B9A1-595968CC8FA6 Configuring Oracle Analytics Cloud E81766-47 January 2022 Though there is an…

Thank you, I know BIP reports are not stored in the Out of the Box Usage Tracking for DV and Analytics. In the On-Prem world there is separate tables within the backend system for BIP that are created via RCU. Then in OBIEE & OAS you can enable Monitor and Audit (A.K.A. Usage Tracking). I am looking for how this can be…

I thought i had previously connected from Desktop to OAC. I got same error when I checked. I suggest opening an SR Here is info on JDBC to OAC https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/query-data-models-remotely-using-jdbc.html…

1) No, that connection is not available 2) you can connect to the OAC/OAS Instance via Oracle Applications connection or via JDBC connection -W

What is the data source? Are you working with RPD/Subject Area? Are you doing this in DV?

Use JDBC connection https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/query-data-models-remotely-using-jdbc.html

One way to force an error in query is to change the select statement to an invalid column name. Or you can temporarily change the column name in the ADW table.

What is the data source? What is used to create data set? What is you are hoping to show / what is purpose?

In Oracle Analytics Desktop there is the ability to apply scripts to a data flow. There is an example script located here http://oracle.com/business-analytics/data-visualization/examples.html Video of the script https://www.youtube.com/watch?v=F32A_G97zrM Note: Running a script in a data flow is only available in Oracle…

so the restore of snapshot when web based model was available did not get you back to that? Have you tried uploading the DUMMY rpd in the snapshot import? that might reset the online modeler

Do you have a snapshot made right after the instance was created, before you did anything with admin tool? Are you saying that snapshot is not restoring the instance to allow access to the web base data modeler? If you opened RPD from Cloud did you save a local copy before editing and publishing? Does current RPD still…

Move Category to Section for Graph

What is the Action Link set on. the Dimension or the Measure? Does your target analysis have a filter for the Dim (Category) you are wanting to pass from dashboard? if action-link is on Measure then the context will pass to the target

Can you use JDBC connection?

The Boxplot would also be a good option

Setting Totals on columns and rows is done in the properties panel