Q&A BY TAG 'Base view'

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

Denodo Views
answered 03-07-2018 08:12:42 -0400

Hi Denodo community, I have the following: Data Source: JSON * Name: HTTP CLIENT * Configure: Post * URL: Rest Call The source currently has nested elements, some fields either appear as a register or arrays. I do not want to...

Answers: 4

post Json Base view JSON

Refreshing a service
answered 22-06-2018 12:41:02 -0400

I have a SOAP service as a data source. We created a base view for one of the the data providers of that service and then we created an Interface to publish our data. We now modified the service and added some more columns that we would like to publish...

Answers: 1

Base view SOAP Interface

info about view settings in metadata
answered 25-05-2018 12:09:45 -0400

Hi, I found this: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures to get information about a lot of metadata. As denodo has a lot of parameters and settings for eac...

Answers: 1

metadata Base view Views

Using CTE WITH clause for creating base view from query
answered 12-04-2018 09:19:08 -0400

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Answers: 3

Base view quer cte MSSQL

How to populate a column in the base view which is not present in the Datasource?
answered 28-02-2018 05:55:50 -0500

I am trying to populate a column in the base view with same value. For example I have manually added "Year" column in the base view which is not present in the Datasource. I would like to populate the Year column with 2018 for all records. How can I do...

Answers: 1

Base view DataSource

How to add by default values in the base view?
answered 26-02-2018 07:48:38 -0500

I have added 2 extra columns in the base view in addition to the datasource. I would like to populate these columns with the same default value. For. e.g. Let's say there are 1000 records in the datasource. I have added "Year" column and I would like t...

Answers: 1

Base view

Edit query when creating a BASE VIEW
answered 22-12-2017 04:52:40 -0500

Hi Community: I'm new using the tool and when creating a base view I used he option create from query. I'm trying to edit the query used for a base view created is this possible? If yes please let me know which are the steps Thanks for your help

Answers: 2

Base view

Denodo base views not accessible
answered 14-11-2017 04:30:51 -0500

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Answers: 1

Missing Base view

Views not accessible
answered 14-11-2017 04:27:26 -0500

Hi, I recently imported our Denodo database to a new AWS environment. The import completed success fully, but when I try to access any of the base view using VQL shell I get below error Finished with error: View 'XYZ' not found but I am able to execut...

Answers: 1

Missing Base view

How to create base view which accepts parameter
answered 05-10-2017 05:32:10 -0400

Hi Team, How to create base view which accepts input parameter? If you can share sample VQL then it will be helpful.

Answers: 1

base view