Latest Activity
I'm trying to create a derived view using the Denodo Design Studio web app. Let's say I have two views: DERIVED_VIEW and BASE_VIEW. These two views have a one-to-many relationship (DV-to-BV). I'm trying to create a new derived view which uses DV as the...
Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...
VQL Denodo 7.0 Base view REST ARRAY derived view data aggregation
Hello Team, I have created 2 baseview(bv_studies, bv_results) of dfferent sources in Denodo. After that, I have created one derived view(dv_final) from these baseview with Inner Join. I am passing 2 parameters to bv_studies. Now the problem is, while ...
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 Please explain in ...
How do we simulate below statement in a derived view in Denodo update fw_denodo_table a set a.column1 = b.column2 from denodo_table2 b where a.column2 = b.column3 and a.column5 = b.column6 and a.year=2019; Please advise
Hi Team, I am getting below error while creating the derived view from joining multiple base view. Accessing the AWS S3 bucket data source from custom wrapper parquet file in S3. [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error accessi...
Hello I want to create a selection view of a derived view that has a column "date" (localdate), and in this selection view I waht to order by date desc, and I only need the first 2 records. How can I do that in denodo? I have this record: 2019-12-01 ...
I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...
Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...
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 ??