Q&A BY TAG 'Parameter'
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
Connecting Denodo views with parameters to Power BI.
answered
23-07-2019 06:58:01 -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:
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
Custom Stored Procedure with default parameter
answered
01-08-2018 15:49:02 -0400
Hi, in java we created a custom stored procedure having a few input parameters. new StoredProcedureParameter("input_database_name", Types.VARCHAR, StoredProcedureParameter.DIRECTION_IN), new StoredProcedureParameter("input_view_name", Types.V...
Answers:
1
ERROR: operator does not exist: timestamp without time zone >= character varying'
answered
19-06-2018 12:38:06 -0400
Hello, I am new to Denodo and because I have a strong background in SQL I have been using my SQL skills by creating base views off a query. When I get to the next step of creating my derived view witha a date parameter I continue to receive the followi...
Answers:
1
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
View Parameters disable
answered
05-04-2018 08:21:54 -0400
Hi! Im trying to do the DEN60EDU118 LAB01. In some point it ask us to use view parametes botton. When im trying to do it, the botton is disable it says: "This feature is not allloed by the licence"! I use de lincense provide by the express instalatio...
Answers:
3