Hi @OAldrich -depending on how many workbooks depend on that dataset- a feature that may help you in that process is the dataset-replace capability. For a given workbook, you can fully repoint it from the original dataset it's using to another distinct dataset as long as you are able to map each column consumed by the…

@User_J6AOQ while Gantt chart is on the roadmap to become a vanilla visualization, we can still enhance the plugin with specific needs in the mean time, let us know if there is anything you are currently missing with the Gantt custom extension.

@Philippe ROGIERS-Oracle , consider checking out the Governance custom extension that is part of the Analytics Library (Analytics Library Extensions for DV | Oracle, scroll down to find this plugin). There is also a YT video that briefly explains it. This will not answer your initial question, but will help you with at…

hi @Philippe ROGIERS-Oracle , is your question to have a session variable hold the datasource file name that the RPD should dynamically point to (this can be done reasonably easy), or is it different than this ?

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