You can translate the question and the replies:

"SELECT top 1 1 as ID FROM <base view> uanble to excute

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM <base view> " for the expected result ID 1 what changes can be done as the expected result thanks in Advance
user
12-01-2021 08:00:03 -0500

1 Answer

Hi, First, I would check if the analytic function you are using is supported by the underlying data source. If yes, check the execution trace to see if it is correctly delegated. You can check the list of supported functions in Denodo in the user manual. * [Analytic Functions](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/analytic_functions_window_functions) Hope this helps!
Denodo Team
13-01-2021 02:26:45 -0500
You must sign in to add an answer. If you do not have an account, you can register here