Q&A BY TAG 'Derived views'
dynamically create derived views based on list of multiple base views
answered
15-11-2021 16:50:51 -0500
Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...
Answers:
1
About Access to view vql of derived views
answered
07-10-2021 19:45:17 -0400
Some one of my team wants to exexcute one derived views that I created, and he also wants to have the read access of that derived views's vql. I grant "metedata", "execute" access of this derived view to him, I think it is the read access we mentione...
Answers:
3
Compounding a derived view
answered
14-09-2021 12:48:18 -0400
Hello, I am working on duplicating the behavior of an API, it works pretty good, all the fields are mapped etc. However, the in-place API expose the data after structuring it : { "cat1": { "a":"toto", "b":"titi" }, "cat2" :{ "c":"tata" } } while the d...
Answers:
2
Joining Census data with Azure dataverse data
answered
04-08-2021 13:11:12 -0400
Hi All, This is probably mainly to get pointed in the right direction. Here's the problem. I would like to be able to geocode addresses as they appear in the Address table. My idea is 1) Create a base view for the REST API from the census. The censu...
Answers:
2
Merge search parameters for derived view to other 3 underlying views
answered
30-03-2021 08:46:37 -0400
Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...
Answers:
1
Building derived views that originally have subqueries in them
answered
16-02-2021 10:07:04 -0500
I have a query that I'm trying to build the logic for as a derived view. Basically, translating my view that is on a DB to Denodo as a Derived View. Trying to figure out that if we have a subquery in the from or where clause, do we have to create anoth...
Answers:
2
Joinin view from different data source
answered
18-11-2020 07:37:05 -0500
I have created 2 views from 2 different folder of same parent folder. Suppose parent folder name is Parent and it has 2 subfolder like subfolder1 & subfolder 2 I have created derived view by joining both views.Now challenge is when I am trying to ...
Answers:
1
Joins in Derived Views (VS) Associations
answered
21-10-2020 07:57:58 -0400
Hello Team, I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Plea...
Answers:
1
Need to extract the second row of a duplicate in a table
answered
20-10-2020 08:03:34 -0400
Hi Folks! I have a scenario where I have a list of customers with a driver number. In some instances, the customer is duplicated because of a second driver being assigned to the customer. Such as this; Customer Driver 101369 5058 101369 5602 How do ...
Answers:
1