If you want a different year -- you will need to have the viz ignore the workbook level filter and then add a new filter either to the canvas or at the viz level. Depending on the goal you could use extract year in a calculation to make it easier for a user to pick different years. Here are list of things you could use by…

That could work. Say your year for the filter is 2024 (the session variable above). Then if you look at table such as "Termination date" you can filter it like this YEAR(Termination Date) = 2024. This would return just terminations in the year 2024. I am not sure what you mean by global in this context. A report or…

@E. van der Poel-Oracle this feature does work and is tested. I recommend creating an SR to investigate what is happening with your situation.

Is this for Oracle Analytics? Perhaps this was meant for an ERP forum?

@Manu R-Oracle which assets do you want purge. Subject Areas tables for example allow you to configure caching rules/behavior. For example, datasets and OAC data flows allow you to schedule reload/runs. There are lot of assets in OAC and it is not clear which you want to control. Can you add some details on the types of…

Have you tried using keys per: https://docs.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File

@JasonJang-Oracle Excel would work. As an alernative -- copy data and then paste in to a CSV will do this:

@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.