Latest Activity

code

Denodo On Demand Training

Hi Denodo Team, I have registered & purchased Denodo on demand Training few years back, I need to revisit my study material for learning purpose. But now i am unable to access the training material? Can you please check why it is happening? my us...

code

Problem with Denodo Scheduler Retry Option

There seems to be some issue with Denodo Scheduler Retry Option. Can you please have a look at this scenario that i performed. Created one cache Job - which will refresh data in every 10 minutes I added my mail id in handler section for receiving...

code

License gone into grace period even the license is valid.

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...

code

Creating Mandatory Fields

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

code

Custom Policy: Query another view

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...

code

Incorrect dates are read from excel

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!

code

Create Base View for Oracle Function that returns Table Type

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...

code

Create a JSON data source and base views following training video

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 ...

code

Optional URL Parameter for HTTP JSON Datasource

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

code

Prior year last business day retrivel

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,