You can translate the question and the replies:

Passing a tableau Parameter from Tableau to a parameterised Denodo Derived view

Hi, I have created a denodo derived view which has a parameter and filter added on that. The paraemetr passes the Customer ID. When i run and test in Denodo, it works fine. I change the parameter default value everytime and it filters the data for that. When i expose this derived view in Tableau, and use this parameter field to pass a value - it does not get passed and only the default value which is defined in Denodo is returned. I have gone through the below URL as well as the documentation by Denodo on the same. It is not working. Can you please let me know where i am going wrong? Denodo documentaion on parameterised Views URL -- https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/creating_derived_views/creating_selection_views#parameters-of-derived-views Another Community URL -- https://community.denodo.com/answers/question/details?questionId=9060g000000L78oAAC&title=How+to+add+by+default+values+in+the+base+view%3F I want to take a customer ID from the User end who uses Tableau and pass this value to Denodo's Parameterised Derived view which will inturn return me the records/data only for the customer ID passed from Tableau and not for the Default Customer ID value defined in the Parameterised view in Denodo. Thanks, Remya.
Parameterize
user
30-05-2019 06:11:52 -0400
code

1 Answer

Hi, In order to give a different value for the View Parameter before every execution, I would define the View Parameter such that it does not contain any default value. This way, before executing the view, I will be prompted to provide the value for the View Parameter. However, in third party client applications like Tableau introspecting this view will throw an error which is expected. Hence, to retrieve the results I would manually query the view in Tableau by adding a 'WHERE' condition for the View Parameter. You can take a look at [Parameters of Derived Views](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views#parameters-of-derived-views) section under the Virtual DataPort Administration Guide for more details. Hope this helps!
Denodo Team
31-05-2019 06:35:42 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here