Skip to Content
0
Former Member
Sep 14, 2007 at 02:54 AM

Horrible Performance in quries

38 Views

Hello guys.

This is Calvin from Korea.

We are implementing BI 7.0 with ERP 6.0 and facing a some problem regarding BI performance. I checked the parameters for both SAP and DBMS, which is oracle as well as cache. And everything seemed to be fine.

Anyway, there are two problems,

The first one is...

When we choose the variable, program CL_RSR_VAR===... executed quite a long time.

and the second one is,

during the query execution time, those events takes lots of time.

OLAP Initialization 18,767479

Wait Time, User 11,011501

..

OLAP: Settings 4,290186

..

Data Manager 3,814428

I tried to find out some solutions by myself but only to fail.

Your help will be highly appreicated,

Regards,

Calvin