Latest Activity

code

How to do the columns to row level convert in Denodo?

Hi team, Does denodo provide the function to do the columns to rows convert? Please refer to belwo table/data example for the transformation we want to do? Let us know how to do it in Denodo side? Thanks. Before: | date | region | book |account |usd_s...

code

List of All DataSource

Hi team, I am using Denodo 8.0 version where I want to see details of all the DataSource created in my server.For which I tried this option 'DESC DATASOURCE <datasource_type> <datasource_name>‘, but in this I have to give one datasource na...

code

Denodo and APIM

Hi Team, Denodo 8.0 Is there any information/document/article available on integrating Denodo API in Azure APIM ? https://azure.microsoft.com/en-in/products/api-management Thanks

code

Denodo installation on RHEL7 CLI without GUI.

I have been trying to install the Denodo in my RHEL 7 CLI which does not have GUI env. i have installed it using installer_cli.sh getting error while executing dendo_platform.sh {x11 variable not faund}. I need help with this ASAP.

code

Get data from api with json format in data catalog using java stored procedure

I would like to extract property groups from denodo data catalog using REST API / JSON in a java stored procedure in order to automatically assign them to new views and interfaces.

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