Skip to Content
0
Former Member
Jul 09, 2012 at 08:42 AM

Different query execution time when run in Bex analyzer and APD

64 Views

Hello,

I come across a strange problem. When query is executed in BEX Analyzer it takes about 10 minutes to get loaded and displayed in excel. When the same query is executed in Analysis Process Designer (simple process which writes query result in DSO type Direct updated) it takes about 2,5 hours.

The query result is quite small, about 10 000 rows and 8 columns. The query is based on multiprovider whisch consists of infocube 0IC_C03 and DSO (write optimized) which contains material prices (with detail for plant and warehouse).

Same situation (2,5 query run) appears when I try generate Intermediate results in APD for this query.

Does anyone have idea why APD query run takes so much time?

System version:

SAP BW release 7.00

Patch level 22

Database system: ORACLE

Release: 11.2.0.3.0

Thank you