Q&A

Custom Policy: Query another view
answered 25-08-2021 17:56:16 -0400

Hello, I'm trying to query another view inside custom policy I've tried loading the driver class using: Class.forName("com.denodo.vdp.jdbc.Driver"); I also added the denodo-vdp-jdbcdriver.jar when compiling my custom policy. The error that oc...

Answers: 3

custom policy

Incorrect dates are read from excel
answered 25-08-2021 12:37:39 -0400

Hi Team, Theres error when reading date from excel 9/1/2020 10/1/2020 11/1/2020 12/1/2020 Above values are read as following in denodo 7/1/20 8/1/20 9/1/20 10/1/20 Any suggestions? why? Thanks!

Answers: 1

Create Base View for Oracle Function that returns Table Type
answered 25-08-2021 07:21:24 -0400

I am trying to create a base view on a Oracle function that returns data type - TABLE Trying this from the normal flow gives error : "Unsupported type TABLE for Database : Oracle Stored Procedure" How can i create this using a "Create Base View from VQ...

Answers: 1

VQL VQL Base view Custom Functions Stored Procedure Oracle

Create a JSON data source and base views following training video
answered 25-08-2021 03:13:10 -0400

Hello team, I am trying to create the base view “ bv_sales_all_array ” and “ bv_salesall ”. Data source of JSON is connecting successfully and these two base views are also created. But when I tried to execute base view and I cannot get the results in ...

Answers: 1

Optional URL Parameter for HTTP JSON Datasource
answered 24-08-2021 06:16:40 -0400

Hello, Is there a way to create interpolation variable and make it as an optional for GET Request on HTTP JSON datasource

Answers: 1

JSON Datasource

Prior year last business day retrivel
answered 24-08-2021 03:11:16 -0400

Hi there, I am trying to retrive last business day of last year though this query select dateadd(yy,datediff(yy,-1,@date),-1)[In sql], but in denodo I am not able to find any solution here, so can you please help me out, Thanks,

Answers: 1

denodo7 query

MAX function for int field - filter for the result?
answered 23-08-2021 08:42:19 -0400

is there an easy way to set a filter to only keep the max value for a field based on two other columns? is greating a group by view with the max first and joining that to the baseview the only way to accomplish this? There are two fields that make th...

Answers: 1

max function Aggregate Group By

Long time execution | No. of rows Variation in results
answered 23-08-2021 07:06:47 -0400

What is the problem when execute, it takes more than 1 minute to execute and shows variation in records? Sometimes shows error also.

Answers: 1

#Source Data Error executing

Custom policies - Trying to get data from Denodo base view
answered 23-08-2021 04:36:06 -0400

Using Denodo 8.0, I'm trying to build a custom policy that will be applied to a specific derived view, that works this way: When user tries to access the data of a derived view, the policy checks to see if the current user is in a config table. If th...

Answers: 6

Denodo 8.0 custom policy jmx

Denodo 8.0 connect to JDBC failed
answered 23-08-2021 01:32:11 -0400

I use denodo 8.0 and mysql 8.0 to connect JDBC, test connection is show Unable to establish connection: Access denied for user 'root'@'localhost' (using password: YES).

Answers: 1