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

Please be more specific.

How are you setting the filters? Are you pinning the filter ? Have you tried Viz specific filters (located in grammar panel not the top)?

yet in Analysis it same dataset behaves fine

take a look at the new feature in 5.7 https://www.youtube.com/watch?v=-3ALDy2ldP8&list=PL6gBNP-Fr8KVkoAS84vm1XbYEu_73o0E8&index=12&t=0s

While a bit dated the concepts are still the same The following is from Oracle Learning Library https://apexapps.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24_PREV_PAGE:9787,2

please share your rtf