Skip to Content
avatar image
Former Member

BEx translated sql from Hana view for Material Stock

Hallo experts,

i have created a Script Calculation view to get the material stock and i have mapped it to an Open ODS view. Upon this Open ODS i have created an Bex querry. When i run it for 1 material it runs fast, but when i run it for multiple materials it takes forever. In the Hana sql server i can see the sql that takes for ever to run and its an sql without any material filter. The problem is the way bex querry is translated to sql, since the same amount of information is easy to get with an sql directly on the same Calcualtion view.

Any thoughts?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers