Latest Activity

code

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...

Parameterize

code

Extracting query with the hardcoded values not parameterized.

Hi, Currently we are running a query which has a lot of hard coded values. The query in its execution plan shows up like below Select as column1, as column2 from table; parameters = [<parameter1>, <parameter2>] How can I extract a que...

query plan Parameterize Query Execution plans Parameter

code

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Parameterize slow query Parameter derived view Tableau

code

Parameterized view join with other views

Hi Experts, I have requirement to join parameterized view with other views (not parameterized) . for that I have created parameterized view(buss_day_clndr) when I query this view alone with below sql it works fine. select count(clndr_dt) from buss_da...

Parameterize

code

Multiple "WHERE OR" conditions for multiple parameters on view

With Denodo 5.5, is it possible to parameterize a view with multiple parameters such that it uses "OR" in the constructed "WHERE" clause? I want to do a select where a particular string may appear in one of several different fields, and I want to selec...

Parameterize