Q&A BY TAG 'Parameterize'

You must sign in to ask a question. If you do not have an account, you can register here

Passing a tableau Parameter from Tableau to a parameterised Denodo Derived view
answered 31-05-2019 06:35:42 -0400

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

Answers: 1

Parameterize

Extracting query with the hardcoded values not parameterized.
answered 29-08-2018 05:33:44 -0400

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

Answers: 1

query plan Parameterize Query Execution plans Parameter

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)?
answered 12-06-2018 12:50:33 -0400

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

Answers: 1

Parameterize slow query Parameter Tableau derived view

Parameterized view join with other views
answered 09-02-2018 07:29:49 -0500

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

Answers: 4

Parameterize

Multiple "WHERE OR" conditions for multiple parameters on view
answered 08-04-2016 20:28:15 -0400

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

Answers: 1

Parameterize