You can translate the question and the replies:

Will it be possible to create a summary view on top of a derived view which has mandatory parameters ?

Hi Team, Was exploring on the Summary feature of Denodo, wanted to check few things regarding below points: 1. Can we create a Summary on top of a Derived view, which has mandatory parameters enabled ? Can this implementation be made dynamic based on the values of the paramters passed by the user on runtime ? 2. Is there any way to make the Remote table data re-load incremental ? (Instead of delete and re-load in each refresh) 3. Is it mandatory to add GROUP BY or to choose a view having GROUP BY enabled to create Summary ? Please help us out regarding the same. Thanks !
summary
user
05-03-2024 09:22:13 -0500
code

2 Answers

Team, pls help us out with these queries!
user
07-03-2024 01:08:06 -0500
Hello, 1. You can create a summary by dragging a derived view from the server explorer to the VQL Query section as outlined in the guide for [creating summaries](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/optimizing_queries/summary_views/managing_summary_views/managing_summary_views#creating-summaries). Any error in the desired view that prevent it from being compatible for a summary view will be presernted with a helpful message when attempting to save the view for example, attempting to use a dervied view with parameters will return unsuccessful with an error like "Subview with parameters are not allowed". 2. Yes this reload can be made incremental through usse of the Denodo Scheduler. For more information on how this can be acomplished [check](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdpdataload_extraction_section) here with the [Summary Load Process](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdpdataload_extraction_section#summary-load-process) section. 3. When you are defining the query to be used to create the summary view the query must contain at leat one JOIN or one GROUP BY in order to be successful. As long as there is a JOIN in the desired summary a GROUP BY should not be needed. You can also review [this article](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/optimizing_queries/summary_views/summary_rewrite_optimization/summary_rewrite_optimization#) for more information about how the summary views are used by the Denodo Query Optimizer and some best practices with summaries. Additionally, here is a tutorial video for [creating summaries](https://community.denodo.com/videos/details/Data%20Combination/Denodo%208.0/Creating%20summaries) if you are interested in getting started. Hope this helps!
Denodo Team
07-03-2024 11:22:56 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here