Q&A

Hello Team, As we have a view for cache column "GET_CACHE_COLUMNS " here we can get the view and cache column mapping. My question is the cache columns are like field_1,field_2... Is there any setting or something were we can populate the view column ...

I have a base view and an interface for the base view. In both the base view and interface one of the columns, ReportingDate, is defined as a timestamp. Using ODATA, I am able to invoke the endpoint and get back results. I can also add a filter conditi...

Hi Team, I am in middle of Denodo 7.0 to Denodo 8.0 migration. We have to enable SSL/TLS in all modules of Denodo. I am refering to the below link in the pre upgradation tasks. https://community.denodo.com/docs/html/browse/8.0/en//platform/upgrade/pre...

Hi All, When trying to create a rule in resource manager using roles.value condition getting error like below: Error editing resource manager rule: field not found 'roles' in view with schema Same seems to work in dev environment but not in UAT.

Hello I am trying to split a comma separated string to multiple columns . I am not able to find an easy method to do it using the available functions. Essentially I have a field called carmodel in the datawarehouse.It has multiple model separated by a...

Hi, Has anyone be able to connect to AWS Athena or AWS DynamoDB? There is already a question about connecting to Athena, but it is from May 2017. I am open to using third party drivers (CData, Simba etc.) if generic drivers will not work. Thanks!

Is there a way to dynamically create the headers for the pivot based on the values in the data? for example if I have a field that has a mapping type that can either be "sector" or "region" and then have a value by person. and end up with a cross tab t...

Related to: How to Pivot and Unpivot views

I'm creating a custom policy but getting an error when trying to use the Denodo method getElementDatabase(); The other methods DO work from my library imports (getQuery(), getElementName(), getCurrentUserName()) - but NOT getElementDatabase(). I was g...

Denodo Platform 7.0

I am unabel to connect to Denodo Open Sandbox. I am using Denodo 8 Express. Your Sandbox URI is: //sandbox.open.denodo.com:9999/vdb_p8yhdf Getting below error. Connection Error : Check the host name and port number are correct, and thet client an...