You can translate the question and the replies:

Unable to use the analytic function in Denodo-VDP

Hi, I am trying to use the analytic function in my derived view in VDP. but it did not recognize the functions and getting errors. (tried all the analtic functions , I got the same errror.. see attached the error detail hyperlink) ![https://imgur.com/a/kSbDR](http://) rank() OVER (PARTITION BY brandcode ORDER BY salesdate DESC) AS rnk Datasource is Teradata. Please let me know if we need to enable any settings in "Source Configuration" Tab for the Teradata Datasource. VDP Server : 6.0 20170515 Thanks, Senthil.
user
12-10-2017 13:56:11 -0400
code

4 Answers

Hi, I would verify if the analytical functions used are added to the 'Delegate analytic functions list' in 'Source Configuration' tab of the datasource. You can select the checkbox and add the required analytical functions seperated by comma. Virtual DataPort can delegate these functions to a database, but cannot execute them. You can refer the[ Analytic Functions](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions) section of Virtual DataPort VQL Guide for more information on the analytical functions supported by Virtual DataPort for delegation. Hope this helps!
Denodo Team
17-10-2017 04:50:43 -0400
code
Hi, Inspite of enabling the delage analytic functions list on the Oracle data source the below query is failing with error "Function row_number is not executable". select Department_id, total_sal, row_number() over(partition by 1 order by total_sal desc) as sal_rank from( select D.department_id, sum(salary) as Total_sal from bv_hr_or_employees E left outer join bv_hr_or_departments D on E.department_id=D.department_id group by D.department_id order by 1 ) However if I use row_number in a select clause executing directly on base view it's working. I couldn't understand why it's failing in the first case.
user
03-04-2019 05:49:30 -0400
Hello, I believe you asked a similar question here: [**Analytic function row_number() is not executable when executing it over a subquery**](https://community.denodo.com/answers/question/details?questionId=9060g000000g03dAAA&title=Issue+with+SSL) Please refer to the response there and feel free to reply directly in the thread if you wish to continue the discussion. Hope this helps.
Denodo Team
25-04-2019 08:51:01 -0400
code
Hi, The community question link which I referred in my last answer is incorrect. Below is the right one: - [**Analytic function row_number() is not executable when executing it over a subquery**](https://community.denodo.com/answers/question/details?questionId=9060g000000bm37AAA&title=Analytic+function+row_number%28%29+is+not+executable+when+executing+it+over+a+subquery) Hope this helps!
Denodo Team
25-04-2019 09:12:14 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here