Latest Activity

code

There was an error processing the privileges for this query

I have already assigned grants to the user to execute the view, but when the user uses the data catalog to execute the data, it's returning an error: "There was an error processing the privileges for this query" What's wrong with it??? These are some ...

code

moving SM from region one to another

Hi Team, Denodo 8.0 SM : installed in Region A VDP : Installed in Region A VDP : Installed in Region B In this scenario, if we wish to uninstall SM from Region A and install it in Region B (that also means that we do not need Region A VDP, we only n...

code

UNION of 21 views

Hi, We have 21 excel files as data source, and we have created base views from those. Then we have craeted selection views from these 21 base views. select distinct id from view1 where id<>'' All the 21 selection views are created in the same w...

code

Getting Errors with MDX query while creating Denodo V8 base view out of TM1 source data

We are creating a Base View in Denodo v8 using TM1 custom wrapper to fetch a subset of data. We are getting different types of errors, mostly with forming a valid MDX query - One of them is as following - "There was an error while creating this base vi...

code

Incremental Refresh of Summary View

I have a senario where I want to refresh the content of Summary view incrementally. How best I can achieve this by using Denodo Scheduler or other means? In the arcticle, it is mentioned that for CACHE, you have this variable which tracks out when was ...

code

Scheduler report

Hi, How to get the scheduler report details in VDP. Have configured jdbc datasource but still unable to find the exact history

code

Assign property groups to view with vql

How assign property group to views or interfaces with vql.

Related to: How To Use Property Groups in the Data Catalog

code

Delegate geospatial function

Hi Experts, How can I delegate the ST_INTERSECTS geospatial function to my snowflake datasource? In the Source configuration, I see analytic, scalar and other types of functions. How do I delegate a geospatial fumction to Snowflake? Thanks much in ad...

code

Facing error 'Multiple DISTINCT aggregates are not supported at this time.'

While executing the below query i am facing the error 'Multiple DISTINCT aggregates are not supported at this time.' query : SELECT COUNT(DISTINCT (((EXTRACT(YEAR FROM C1))))) COL_1, COUNT(DISTINCT (((EXTRACT(YEAR FROM C2))))) COL_2 FROM TableName

code

Scheduler: Authentication error: The username or password is incorrect

Please assist. When I try to execute a job via schedule the below error appears. I have checked the admin user name password is correct. Caused by: com.denodo.vdb.vdbinterface.common.connection.VDBConnectionException: authentication error: The userna...