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?
SAP BW release 7.00
Patch level 22
Database system: ORACLE