@Michal Zima I think are talking about the same things here. DVA is focused on a personal archiving solution for business users and not working for this scenario. We need a way to promote content between environments -- whether that is DVA or BAR or something else. This is the main capability here if understand the goals…

@Michal Zima would improvements in the BAR framework be solution here? DVAs are currently focused on individual users managing their own assets. I think the idea here is more about supporting developers and mulit-environment scenarios as much as tweaking DVA behavior.

Would SELECT only be sufficient? One difference between OAC and using say the web tools in ADW or ADB is that when you enter manual sql -- we focus on read-only experiences. Perhaps a related idea would be to enable a user to open Oracle SQL Developer Web, create a query there, and then easily add to a dataset (kind of…

We are working on REST APIs for catalog objects. Current Connections have support -- similar to your request (albeit not the same). This is worth looking as for connections as we make more progress on these scenarios. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/api-catalog-connections.html

@Gianni Ceresa did a good job describing factors and an approach. And having OAC in the same region as your main data sources is typically beneficial.

Role-based filters for datasets can achieve a similar capability if you have some data you can use for the behavior you are after. https://blogs.oracle.com/analytics/post/ensure-consumers-of-your-datasets-only-see-data-relevant-to-them-by-using-the-role-based-filters-feature-in-oracle-analytics-cloud…

One option is to use the Metrics monitoring in OCI for query capacity. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/administer-services.html#GUID-F6D90D87-BDBB-49F3-8E54-322F9A4C1E31

A potential work around is to create a measure from the attribute and then use that for the conditional formatting or cross row formatting. Also you can use icons too now https://www.youtube.com/watch?v=IrnnJgP__Qg

Is using RSUM as a calc in this scenario a reasonable work around?

Do you want these to be multiple tables -- each with different sets of columns?

In general, it is better to not have multiple sets of jobs for data replication but to have them run as one set. What is the scenario for sequencing them?

We don't have an approach for data replication jobs. For data flows, you can review Gabrielle's new blog. https://blogs.oracle.com/analytics/post/oracle-analytics-data-flow-notification-system

@Marcelo Finkielsztein for the API/coding approach we can definitely help and we can update the documentation/blogs based on working with you on it.

@Sean McArthur for the comment on edit definition -- you need read access to a connnection (that is the ability to use it) to edit definition. You don't need the ability to modify a connection to use edit definition. If you are seeing something else, let us know. For the overall topic - we looking at options.

This is useful!

Note -- in addition to changing the visible name, you can also create a new dataset and use the "Replace dataset" function in a workbook. If you have a lot of workbooks using the same dataset, this may not be a good work around.

I can't think of a reason this should happen. I can reproduce it for my OAC as well. [Update] -- it is actually working as expected. The difference is that the export to excel works for just one visual. When you select the visual in the canvas ... this let's the export button in the chrome know that you are able to export…

CSV is a view of the data in a simple row/column format. Can you create an example from sample data of what you are looking for? The purpose of supporting excel format is to allow things like a pivot table.

You can do this today in the dataset if the formatting applies to all of your workbooks. Have you tried this approach?

Thanks Dan. Understood. Right now there are still things you will need to do with the command-line or admin tool. Semantic Modeler is a work in progress!