@Ciaran thanks, about the 23c Graph capabilities, these are not yet integrated with OA. OA currently only leverages Nw Graph calculations (not vizs) via the legacy SQL API of the db, and the visualizes results directly with an OA viz. See these videos for example https://youtu.be/Q80ERcTMQW8, https://youtu.be/b_S9E8aWdYY,…

You are correct @AGilabert, sorry about this, over time we had to remove the prebuilt projects as the data structure itself for maintenance/legal reasons related to data itself. However, once you get the dataset outputs from the plugin itself, it should be fairly straightforward to query these with OA, let us know if you…

Thanks @Gianni Ceresa , about the needed catalog API being public or not (yet), it's better to contact PM directly on this - I don't have the exact info about it. Just email me if you want to follow up on this and I will circulate. One more note, about your remark on '...have tools in place to evaluate impact analysis when…

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…