You can translate the question and the replies:

Error when using RANK function for SAP data source

Hi, I am getting error while using a RANK function in Denodo v7. Error: "Finished with error: Error executing view: Function rank is not executable" Please let me know Will denodo support RANK function for SAP data source? If Yes, let me know how to frame the logic for below SAP BO RANK logic, RAnk function for, SAP BO: =Rank([Retail sales value];([Store (retail location)];[Transaction number];[Material]);Bottom;([Store (retail location)])) Thanks in Advance!
user
15-03-2021 07:46:30 -0400
code

1 Answer

Hi, According to [this manual](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#analytic-functions-window-functions), Denodo supports Analytic Functions such as RANK function means that it can delegate to the data source, not execute it. In other words, if something blocks the delegation of the query including Analytic Functions entirely to a data source, I will get this error. In order to confirm if the query is delegated to the underlying data source, I would check [Execution Trace](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/execution_trace_information/execution_trace_information#execution-trace-information). I found the relevant info in the following manuals. I believe these should be helpful to you. * [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/generating_wrappers_and_data_sources/creating_data_sources/data_source_configuration_properties) * [Analytic Functions(Window Function)](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions#analytic-functions-window-functions) If the issue persists and you are a valid support user, you may open a Support Case at the [Denodo Support Site](https://support.denodo.com/) and Support Team will help you. Hope this helps!
Denodo Team
17-03-2021 04:08:03 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here