Skip to Content
1

performance of cds view in BW

Jul 19, 2017 at 07:59 PM

38

avatar image

Hello,

we have try to implement an Open ODS that is based on a Datasource that is based on a CDS view.

We have noticed performance issue in quality system where the source table is 70 millions of records . When i try to do a preview of the data, the system hang out for a long time even if i display 20 records.

in sm50 we have a program that run for a long time and the number of line read is several millions of records.

I dont understand why the sap program is reading all the record to display only 20 records.

Have someone faced a similar issue with Performance in BW based on CDS view ? how have you solved it ?

Best regards.

Thank for your help.

sm50.png (35.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers