Q&A

License gone into grace period even the license is valid.
answered 26-08-2021 04:00:58 -0400

Hi Team, The license has gone into grace period even there is validity for license is there. Also when trying to start the vqlserver_startup.sh it is giving some error stating "bad substituition". Solution manager and license manager are in running st...

Answers: 1

License DENODO EVALUATION LICENSE

Creating Mandatory Fields
answered 26-08-2021 02:49:51 -0400

Hi, Is there a way to create a mandatory fields for views? PS: datasource is JDBC not JSON Thanks

Answers: 1

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