Q&A BY TAG 'Parameter'

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

Denodo Parameter Error - without search methods
answered 18-02-2020 05:35:01 -0500

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: 1

search methods 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

Parameter View Parameter entry derived view

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

Parameter View Parameter entry selection view

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

Power BI Parameter Power Query

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

input REST multiple Parameters parameter

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

ODBC Power BI Custom Connector Parameter

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

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

Denodo stored procedure custom Parameter

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

query Parameter Date timestamp

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 derived view Tableau