You can translate the question and the replies:

Analytic Functions (Window Functions) using denodo 8.0 Error executing view: Function row_number is not executable Any possible ways to use Analytic Functions in denodo

Analytic Functions (Window Functions) using denodo 8.0 i have added functions into datasource (oracle19c) using source_configuration still getting below error Error executing view: Function row_number is not executable Any possible ways to use Analytic Functions in denodo
user
18-02-2021 03:17:29 -0500
code

5 Answers

Hi, If I face such an error, I would check if the **[ROW_NUMBER()](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#row-number)** function is available in the list of analytical functions in the Source Configuration tab. In general, Virtual DataPort can only delegate the analytical functions but cannot execute it. Hence, I would make sure that the query is delegable to the underlying data source. You could find a similar question answered [here](https://community.denodo.com/answers/question/details?questionId=9060g00000009rMAAQ&title=Function+row_number+is+not+executable). You can also take a look at the [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/generating_wrappers_and_data_sources/creating_data_sources/data_source_configuration_properties) and [Analytic Function(Window Function)](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions) Sections of Virtual DataPort VQL Guide for more information. If you are a user with valid support account then you can raise a Support case in the [Denodo Support Site](https://support.denodo.com/) and our Support Team will assist you. Hope this helps!
Denodo Team
18-02-2021 07:23:00 -0500
code
Hi Denodo Team, I have added already source configuration but still facing the issue you are using oracle-19c. we have to use oracle-11G is mandatory?
user
18-02-2021 07:47:13 -0500
Hi, Virtual DataPort expects a query to be completely delegable to the underlying datasource since it cannot execute analytical functions. If I get the **Function row_number is not executable error**, I would check the [Execution Trace](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/appendix/execution_trace_information/execution_trace_information) to see if the query is delegated to the underlying data source. If you still need help and if you are a valid support user then you can raise a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team can help you. Hope this helps!
Denodo Team
26-02-2021 02:19:45 -0500
code
I experienced the similar issue for using Teradata connection as the data source. Couple items: 1- Design Studio does NOT contain the Delegate Analytical Functions setting. You need to login to the server and use the VDP tool. 2-We were able to resolve this issue in VDP tool by going to the settings of the data source connection changing the Delegate Analytical Functions to 'Custom' and adding an entry for row number function in the text box next to it as ROW_NUMBER()
user
09-08-2022 16:57:23 -0400
Hi, I'm glad you are able to delegate the ROW_NUMBER() analytical function by changing the property to 'Custom' and manually adding an entry in the data source configuration. Hope this helps!
Denodo Team
11-08-2022 07:14:15 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here