Hello, Please find in attachment th detail of the queries generated : 1) without any filter (so giving the complete year of 2023); 2) with a explicit filter on 3 days (from 20/11 to 22/11); 3) with a relative filter of 4 days to get the days from 20/11 to 22/11). The last one give us an error, number of rows exceeded.…

Hi, We have the same kind of issue : a dataviz created in english is not displayed in French User Interface. Regards. Jean-Pierre

Hi, I can indeed bind a parameter to a "Dashboard Filter" to store the selected value (in my cas the date selected by the user in the parameter "P_DATE_VALEUR"). Then I would like to get the corresponding week in the date dimension table. So I try to create another parameter with the following "Logical SQL Query" : SELECT…

Thank you Gianni and Ezequiel, I know how to proceed now. Regards. Jean-Pierre

@Michal Zima Hi Michal, I have just voted for your Idea which is indeed also our need. I will produce a document with some detail of our use case and will share it with you and the Analytics team. Best regards. Jean-Pierre

Hi, If we can indeed use the JDBC connection to Denodo views, the reload of the Dataset failed in error. So actually it's unfortunately unusable and we are still waiting for the connection to Denodo to be fully functionnal because our data architecture is based on Denodo and without a quick solution to that issue, this…

I've done some further testing and could manage the following use case : promoting from one environment to another a shared folder that contains visualizations and classic artifacts, with the Dataset(s) and the Connection(s) used by the visualizations. The process that fully works is : * archive the folder located in…

Indeed importing in the target environment the dva file of a folder brings both the DV pieces and the classic artifacts. The last trouble is that the folder is restored in "My folder" instead of "Shared folders". I could move it but then the path to the artifacts in the dashboard page are wrong and I have to replace them…

I see that the "Export" functionnality is also available on a "Folder" ... Does that mean that all the content of the folder could be exported and the imported in the target environment, even "Classics" artifacts like Dashboards, Prompts, Requests, Agents, .... ?

Indeed, both the connection definition and the dataset is imported inthe target environment. So this workarround does the job. Thanks again Michal.

Thanks Michal, I suppose that furthermore we have to create the datasource connection under the exact same name ? Jean-Pierre

Hi, Indeed we have to manage backups to be safe, but what is also needed is to restore one dataset and not the entire snapshot ... Moreover that functionnality is also relevant to promote a dataset from DEV to PRD. Does anyone have a solution for that need please ? Jean-Pierre

Indeed, we can manage access to the datasets, but this does not have any impact on the data's cache which seems to be user related (in other words, each user needs his own cache). Does anyone have some information / documentation about that XSA storage (as an example, this is a part of the query log that is a reference to…

Hello Alan, hello Bala, I have raised a new SR : SR 3-31617576691 : Troubles with JDBC Connection to Denodo Thanks a lot for your help, I appreciate. Regards. Jean-Pierre

Hello Bala, We are indeed using the JDBC connection in DV (but it would also be a plus to use the Denodo views in the RPD with a RDG connection). We have already create a SR six months ago (SR 3-29662967251 : Unable to reload a JDBC Dataset) but with a poor "unsupported database" answer ! Even as part of the "Analytics…

Yes of course.

We also need SAP Hana as a certified data source.

It could also be usefull regarding GDPR compliance.

Indeed, catalog manager should offer the same functionnality for DV projects as for objets from classic.

We also need to have audit data about usage of connections (which datasets are using each connection) and usage of datasets (which projects).