Latest Activity

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,

code

MAX function for int field - filter for the result?

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

code

Long time execution | No. of rows Variation in results

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

code

Custom policies - Trying to get data from Denodo base view

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

code

Denodo 8.0 connect to JDBC failed

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

code

Query for eliminating non-dependent/unnecessary views

Hi, I have migrated views to QA environment and there are some views that are not dependent of the final Interface view, to retrieve the dependent views, I use this query : SELECT DISTINCT view_database_name, view_name, view_type, private_view, depen...

code

Prioritize operational over analytical queries

Hi, Can I check how can prioritze operational queries over analytical queries? Can I check if the above question can be achieved in resource manager? if yes, if there's any documents that I can refer to do the setup? Thanks!

code

Link broken in Usage Statistics (404not found)

Load the Denodo Incremental Cache Load stored procedure in Denodo Virtual DataPort. The link was broken in 「Denodo Incremental Cache Load」part. Usage Statistics

code

Denodo Pagination - JSON Source

I am facing an issue while paginating the data. We are getting response details in JSOn format and we are simply passing the path of that next page in JSON data source. But the Denodo Pagination mechanism is something where complete URI will be replac...

code

Not able to use order by clause for multiple columns

hi i have joined two views and i am trying to use order by clause on the view with the provided functionality in denodo 7 . but i am not able to use two or more columns, Is there any way i can use order by on the integrated view for multiple columns