SAP BW on HANA BEX Query performance improvement?

[bl_vijaykumar]

HI All,

we are facing an issue with Bex queries of a model while running, run time is around 18-20 minutes.

Model consists of a Scripted CV where inputs toweek , from week and company id, with a simple select statement which bring data for required fields from a Analytical view.

This Scripted CV is been used by other 5 different CVs and then a composite provider then a Bex query.

i suspect slow performance is due to more data in the BW models.

DSO 279,522,937 records

3 different cubes 546,635,673&429,516,705 & 2,021,144,029

please provide me if you have any suggestion how to overcome this performance problem

Thanks

Vijay