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
Top N DENODO denodo with tableau SAP SAP BW/4HANA
user
12-01-2021 08:00:03 -0500
code

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
code
You must sign in to add an answer. If you do not have an account, you can register here