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.

get_view_columns
answered 01-10-2019 06:44:41 -0400

We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. ...

Answers: 1

Microstrategy VQL get_view_columns

In view row_number() is not working expected.
answered 01-10-2019 06:13:59 -0400

In view row_number() is not working expected. but same query from VQL Shell giving me expected results. What is the issue ? I pass same where clause. From VQL shell which is need row_number 1 1 2 3 4 From View row_number 49 50 51 52 115 What caus...

Answers: 3

VQL Vql shell row number

Performing denodo tasks from Jenkins
answered 01-10-2019 04:17:26 -0400

I am trying a create a working prototype for performing denodo activities from my Jenkins server. Steps that i want to perform are : Import a VSQL file from GIT to Denodo from Jenkins. Create a view in Denodo from Jenkins. Run this VSQL file in Denod...

Answers: 3

Jenkins DENODO

consistent user & role management
answered 30-09-2019 18:45:55 -0400

Hello, what is the recommended way to have consistent users and roles on VDP clusters with multiple nodes? Can the solution manager be used for this? At the moment, we have to manually implement changes/additions to users & roles in VDP admin mu...

Answers: 1

Association will take effect on snow flake schema join?
answered 30-09-2019 06:41:20 -0400

Dose associations take effect for the snow flake join, for example, fact join dim_A,Dim_B, are star schema join, and join Dim_c, Dim_C join is not on fact column, it is on DIm_A and Dim_B column, how to make the association take effect?

Answers: 6

snow flake schema Association

How is the export properties file generated?
answered 30-09-2019 05:13:45 -0400

Working on automating a process of exporting a folder and its contents from one VDB and importing into another. We currently use the UI to export a folder and properties file then import to another VDB. The export tool will create a VQL and properties ...

Answers: 3

row_number() on flat file data source?
answered 27-09-2019 20:47:30 -0400

I have a flat file data source. I'd LOVE to use row_number() OVER ( PARTITION BY id ORDER BY id ASC ) against my flat file data source. But when I do, I get this: Finished with error: Error executing view: Function row_number is not executable I sa...

Answers: 1

issue with pagination in REST API call
answered 27-09-2019 09:16:58 -0400

I've configured a datasource with an http path of https://company.service.com/api/v1/entities?firm=2. The API uses next page pagination and so I've set those paramters up as well. when I run a query in my base view and look at the execution path, I see...

Answers: 1

Nothing happens on clicking Denodo icon
answered 27-09-2019 08:09:20 -0400

Hi i have installed Denodo software and can see Denodo shortcut icon on the desktop screen. However when i double click the icon nothing happens, also i tried clicking the icon in the actual location folder and nothing happens, i mean Denodo does not s...

Answers: 3

installation cannot use icon new installation

SQL Collation conflict between base views on different servers.
answered 27-09-2019 08:07:31 -0400

This error message is sent when executing queries against two joined sql tables: QUERY [JDBC ROUTE] [ERROR] Received exception with message 'Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in th...

Answers: 3

sql collation