Q&A

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

Denodo Express Server connection with Power BI
answered 11-07-2019 08:03:54 -0400

Hello Everyone I am new to Denodo. I wanted to know if it is possible to get data directly from denodo server ( not denodo vitual data port ) to power BI?

Answers: 3

DENODO Connecting to remote databases