Q&A BY TAG 'Parameter'
On base views created from query with parameters-how can we pass the parameters from a subquery in where statement
answered
14-06-2022 05:57:06 -0400
I have created a base view from query which contains parameters that I need to pass in order to get the result set. Base view name is bv_root_table. Parameter for the base view that is required that we pass is AccountID field. I am trying to execute a...
Answers:
3
Invalid query in create base view from query View without search methods baseview created from query Parameter Subquery
Denodo Parameter Error - without search methods
answered
13-06-2022 07:45:22 -0400
I created a view with a parameter. If there is specific value typed into that parameter the view processes just fine.However, I need the parameter field to be blank, so when you open the view the end user has the option to type in the parameter they ar...
Answers:
3
How to restrict results returned in PowerBI using a parameter?
answered
04-05-2022 12:25:18 -0400
we have a table in denodo with a time dimension, can we restrict the number of results using a parameter in PowerBI?
Answers:
1
Connecting Denodo views with parameters to Power BI.
answered
29-07-2021 17:03:26 -0400
I've been working with a few Denodo views and am looking to bring the final view into Power BI. However, I need to somehow define the required parameters as I'm connecting the view or else Power BI will return an error. I would like to connect these de...
Answers:
2
Changing parameter
answered
30-03-2021 08:40:58 -0400
Hi there, I have made one comparision parameter in a join view, like input '=' or 'in' localdate(2201/02/03) but if I want to add between range here, then what changes I have to do and how it works. I am trying to chnage it but it won't work.
Answers:
4
To add a parameter to a derived view
answered
14-01-2020 02:37:03 -0500
I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...
Answers:
3
in selection view, is there any way that input parameter can accept values from subquery rather direct assignment
answered
10-01-2020 19:26:28 -0500
in selection view, is there any way that input view parameter can accept values from subquery rather direct assignment of values. if i assign values through sun query like below SELECT GETDAYSBETWEEN(in_from_effective_date, in_to_effective_date), p_p...
Answers:
1
Multiple input parameters in REST service
answered
07-06-2019 08:32:57 -0400
HI Please let me know how to pass or query multiple inputs for a REST service. Eg. If my REST service has a view with 'Rollnum' in where condition then how shall i fetch the records for the roll numbers "1,,3,6,7" in one go ? Thanks
Answers:
3
Required Parms in Power BI Denodo Custom Connector
answered
28-05-2019 11:15:14 -0400
I am trying to use the Denodo Custom Connector in Power BI but I keep getting errors when the interface I want to use has a required parameter. How can I get around this problem? (there is a similar issue with ODBC and I'm hoping the answer isn't to wr...
Answers:
5
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