Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Business View
answered 11-05-2017 07:49:07 -0400

Hi Team, Can Denodo by directly used by business user so that they can see data leneage , sample data and denodo models. Thanks Deepak

Answers: 1

reading data from a MS SSAS Cube
answered 11-05-2017 00:17:19 -0400

Good Afternoon. Denodo 6. Reading data from a SSAS Cube can be accomplished by: use xmla which implies IIS (mandatory ?) use a MDX query to generate the view (this one requires nothing special like IIS, etc) please let us know which statement ...

Answers: 2

Denodo and In-Memory Data Grid's
answered 10-05-2017 18:26:35 -0400

Hi, I'm interested to find out if there's anybody using Denodo with an In-Memory Data Grid (e.g. VMware Gemfire or GridGain)? How would this typically be configured from an architectural point of view? Many thanks.

Answers: 3

In-Memory Grid

Restrict query to different data sources
answered 10-05-2017 11:00:42 -0400

Hi Support Team. I am trying to restrict the query to fire different data sources for increase the performance. given below is the bussiness requirement details There is 3 different sources(ex. SOURCE1, SOURCE2 and SOURCE3), we created 3 different vi...

Answers: 1

How to pass on Values from an XML Request to its corresponding Response
answered 10-05-2017 00:26:37 -0400

Hi, When i create a new project with the below steps New --> Data Source --> XML and then I am succesfully able to configure the project and create a base view too. But when I try to deploy this as a web service, i do not face any problems while...

Answers: 1

XML request to response

In Memory - Caching
answered 09-05-2017 16:07:23 -0400

Hello Team, Which In Memory caching can Denodo work with , i am aware of Denodo can be used with Oracle Times Ten / SAP Hana but how about open source Data GRID like Apache Ignite or GridGain or Gigaspaces? Will it only support Relation Data Grid or ...

Answers: 6

Data Grid imdg In-Memory Grid

IGNORE NULLS
answered 09-05-2017 14:31:26 -0400

Denodo 6.0, latest update as of 4/10/2017: Are we able to specify how NULLs are treated in aggregate and windowing functions? I wasn't able to find any information about specifying the handling of NULLs in aggregrate and windowing functions. In parti...

Answers: 2

windowing_function Aggregate

Caching not working while joining two tables.
answered 09-05-2017 08:00:40 -0400

Hi, I have created two tables X, Y and enables the cache. With the current configuration. X, Y caching works individually. But when I do a join query with both tables. The cache is not working. Can some one help me on this. EX: select from X trace; -...

Answers: 1

cache cache configuration Cache error

Automatic query rewrite
answered 09-05-2017 05:17:12 -0400

Hi, we're explor enodo as a cache platform for EDW, our EDW is built on redshift and we'd like to replic a similar featur to oracle's aggreg uery rewrite within denodo, are there any docs or examplea on how to do this. Our BI tool is cognos and its mo...

Answers: 1
Related to: Advanced VQL Guide

QueryOptimization Queryrewrite

Listing of users list for a period of time
answered 08-05-2017 11:39:25 -0400

Hi Denodo Team, I want to get the list of users in the particular database for the specific period of time. Eg.. 01st jan to 31st march... I want to get the lis of user which are created for the above mentioend period.. How i can get the details?? ...

Answers: 1