I can't think of a graceful workaround for this in current version. Maybe by creating multiple parameters and letting user set distinct values in each variable. That would allow you to sequence the filter syntax with correct 'OR' operators, and would be a robust solution. However that's a somewhat heavier functional…

Thanks @Michal Zima we will follow up on this from the doc side. Watch out the subtleties of the function itself, in particular in the case of multi-tables datasets. You can see some example of the Rowid() function being delivered by the Auto Insights visualizations. Drag some of these in your canvas and check for the…

Hello @User_D8ODJ , do you know up to how many distinct values a user may enter in the filter clause ?

Thanks @Harriet Huang-Oracle , we produced the video to describe how to use this syntax, and it shows that the results of rowid() function depend on the grain that is set in the query. For your example above, it will work 'as-is'.

Hi @Harriet Huang-Oracle , you could simply use the Rowid() syntax, see below. Let me know if not helping your need.

Hi Nachiket/Samar, thanks for that suggestion, the feature as you are describing it is now part of Oracle Analytics (Sept 2023 update). You can see the demo video as part of the playlist bit.ly/OACSep23Features. It handles both attributes and metrics. Thanks again for your contribution !

This capability will soon be added as part of DV maps. Users will have the ability to show data labels directly within maps.

Hello Wayne, happy new year. In this case, the viz engine in DV performs a slightly different aggregation than the one in Answers. Answers Waterfall takes your input data (your result set) already as the 'variation' data, while DV Waterfall considers your result-set data as a the 'balance' data and computes the variation.…

Keep in mind a new capability of exporting/importing only dataflows will ship with OAC 5.4 which is only a few days away at this point. Tks Philippe

another security alternative : move all your projects in your current install under a single folder (within the DVD app), then export that folder as an XSA. It will create a large xsa file with all your projects & related datasets, dataflows etc in it. Later on you may simply restore this dva to get your content back.…

Normally, if you properly un-install and properly do a new install, your content will be preserved. Even if you install into a different path, because the content is stored under /appdata in Windows. A manual double security could be to backup your subdirectory in AppData. In the case of my laptop, the directory path to…

Hello Georgios, can you try this on your environment and let me know please : reinstall DVD, but during the install process please type an install location in Program Files without spaces : for example, C:\Program Files\dvdesktop\ Then see if install_dvml.cmd works after that. thanks Philippe

Hi Steve, if you mark your project with these specific permissions, users will not see the data and grammar pane when opening them : under inspect menu for your project, Click on the Access and the Share menus and grant your users or groups only a view role (both for Access and Share). That will result in what I describe…

Hi Brian, There currently is a feature do render this in Answers (Narrative view) but not in DV canvases (yet). Two potential workarounds that may help : * in DV, use an expression filter instead of a classic filter, and just enter the text there. See the picture below. Since you are using a date object in your case, it…

Hello Wilbert, to have it show as a measure you need to explicitly set an aggregation rule in the calc. Typically Avg in this case, but could be anything else See the picture below with the formula. In this case, the object shows as a metric. You need to be aware of the level of details you bring in your viz, as OAC will…

Sorry Brian, I was trying to highlight the different options. It sounds option two is the best one for you, it's fairly simple to setup, let us know if you can't get it to work tks Philippe

You have two options for this - go the OAC semantic layer (not just a manually created datasource), and create your datasource in the semantic layer (RPD). There you can manage cache refreshes with some set frequency. This requires using the Admintool to design RPD or - keep the source you have now, make it Live, not…

Hi Brian, - if your dataset is set with the data access rule of 'Automatic Caching' (default value, you can see by editing your dataset), it will only look at the dataset cached in OAC. In this case you need to run refresh datasets to refresh everying - if your dataset is set with the 'Live' option, then a simple refresh…

Hello Brian, can you confirm you have the Physical SQL from the DV query, and not just the report Logical SQL ? Another way to check that :can you confirm that your DV data-source has its data-access set to Live and not Automatic Caching in it's property. You can see that and change it by clicking Inspect on your dataset.…

Hi Loret, Christian there is actually a way to share Data-Flows today, not ultra-intuitive but robust. When you build a dataflow that you want to export and share, simply do this : - run the Data-Flow and create a dataset with it (even if 'dummy' data only) - create a project on this resulting dataset (even a 'dummy'…