Skip to Content
0

SAP BW on HANA BEX Query performance improvement?

Nov 21, 2016 at 08:02 AM

112

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers