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

List role by assignment
answered 19-09-2017 05:37:57 -0400

Hi, I have Role A and assgin to Role 1, 2, 4, 5. Right now I have to open Role 5 to check if Role A from role management. Is there a vql to list Role 1,2,4,5 by Role A? thanks

Answers: 1

VQL Role

SSRS Multi Value Parameter
answered 19-09-2017 01:58:08 -0400

Hi, How to create a multi-value parameter in SSRS? In MSsql I do this sql Select * from table1 where column1 in (@values) But when I do the script below on Denodo Select * from table1 where column1 in (?) it returns error. Any Idea on how to pas...

Answers: 1

SSRS

Cannot remove filed in Final View
answered 18-09-2017 09:29:54 -0400

Background: Many columns have already been dropped from the base view. When we try to drop these columns from a view built off this base view, I can drop some but not others through Edit, Output. We get an error message "The selected fields cannot be r...

Answers: 1

Adding Logic to Join View
answered 18-09-2017 08:47:01 -0400

Hello, I am having some issues designing a solution to a feature that I need to create. Scenario: I have a data set with a specific field that needs to be modified when a condition true is passed in from the web service and not modified when a condi...

Answers: 1

VQL REST join Logic Web Service

Varbinary data type not exists in Denodo
answered 18-09-2017 07:58:32 -0400

HI All, We are trying to convert the unique identifier to Varbinary data type. it is not supporting by denodo which can be done in sql.

Answers: 1

Data Lineage Report in Excel
answered 15-09-2017 08:25:38 -0400

I have created and SOAP Service using through multi step approch creating multiple derived views from Database base views. However, I would like to capture all the linege(all intermediate steps) and Base View to Service View mappings in a spreadsheet. ...

Answers: 1

Excel Lineage

Denodo 6.0 scheduler server configuration
answered 15-09-2017 04:29:25 -0400

Hi Guru's In Denodo 6.0, scheduler server configuration to enable cluster settings what are the settings to be enabled if servers are load balanced and Db is Derby.

Answers: 1

Denodo 5.5 and 6.0

create a datasource in denodo
answered 13-09-2017 08:09:57 -0400

Hi, How to create a datasource in denodo connecting to denodo database.? Regards Karthi

Answers: 1

DataSource

how to change from localhost to the host name in ISS
answered 13-09-2017 08:02:35 -0400

Hi , I would like to know how do i change the "Login from VDP" option from localhost to specific host name. Thanks in Advance

Answers: 1

Problem creating base view from SQL Server stored procedure in Denodo 6
answered 13-09-2017 07:06:02 -0400

I am trying to migrate from Denodo 5.5 to Denodo 6. I had a base view named JMPSTART_BV_GETSAMPLE that was created from a query against a MS SQL Server 2014 database. The query is the following call to a stored procedure that returns a resultset: EXE...

Answers: 1