Home / Q&A / All Questions

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

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.

View resultset is limited, how can i retrieve all data
answered 17-07-2019 08:37:54 -0400

hi all, currently i evaluate the community edition of Denodo platform. I want to bencmark the performance of data in with cache options and noncache. I want to measure the elapsed time for retrieveing all data in a view. But when executed query only ...

Answers: 1

resultset limit

Virtual Data Marts
answered 17-07-2019 08:28:57 -0400

Can you give an idea on how virtual data marts can be implemented from Denodo? 1.For existing physical data marts. 2.For developing from scratch within denodo.

Answers: 3

Unable to Import Denodo View in SSAS
answered 17-07-2019 08:26:16 -0400

Hi, I am trying to import Denodo derived view in SSAS. But while importing the Denodo view i am facing the below mentioned error. If any one knows the solution please suggest what i have to do in this case. Error Message : "ERROR [ ] ERROR: Syntax e...

Answers: 4

How to query on different View?
answered 17-07-2019 08:22:31 -0400

I have 3 derived view A, B and C. I want to pass parameter from web services like B then the query agains B derived view. If I pass C then the query agains C derived view. This is possible in Denodo ??

Answers: 3

REST Webservice derived view Interface

Unable to do the Data Search in Data Catalog
answered 16-07-2019 05:17:52 -0400

Unable to do the Data Search in Data Catalog , we have created set of base views and derived view with multiple data sources. While we search the column we are able to see but we are not able to search based on the data.

Answers: 2

#Search #Datasearch

Encountered Log4j2 Error during Denodo Solution Manager 7.0 update -
answered 15-07-2019 07:04:49 -0400

Encountered the error below on the command line in an attempt to update Denodo Solution Manager 7.0 using file denodo-solutionmanager-v70-update-201903122200.jar : ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-cor...

Answers: 1

Import data to SSAS
answered 12-07-2019 12:22:27 -0400

Hi, I have installed the latest 32 bit ODBC driver for Denodo (psqlodbc_11_01_0000-x86.zip) and I'm trying to import the data through SSAS 2012. When I test the connection to Denodo VDB, it's successful, but when I try to import the data I have this e...

Answers: 2

SSAS

RM CPU usage
answered 12-07-2019 09:21:59 -0400

Hello, We have the following Resource Manager rules: CPU usage is equal to or greater than 50% Stop query when query timeout of 200000 (milliseconds) has been reached Set the priority of the threads that execute the query to 5 Set the maximum number ...

Answers: 1

Unit and Currency conversion
answered 12-07-2019 07:49:11 -0400

Hello, How can we do the currency and unit of measure conversion in denodo. We are connecting from SAP BW 7.X and have these requirements. Normally in SAP we have some standard ways to handle the conversions. How do we do that in denodo? Also the key ...

Answers: 1

Error executing view: Memory usage restrictions prevent the execution of the query
answered 12-07-2019 02:58:39 -0400

I am using nearly 30 views and in that i have 3 unions,when i execute the last view I am getting below error: Finished with error: Error executing view: Memory usage restrictions prevent the execution of the query Please help me to resolve this issue

Answers: 1