I'm working on a BW7.0 system and have the following scenario.
There is a MultiProvider based on a single InfoCube. On the MP, there is a BEx query that is used as the source for an APD. The APD is a simple one - it just takes the query result and writes it to a DSO. Now, the APD is extremely slow - it's unable to process 1000 records within 24 hrs.
I created an aggregate on the underlying InfoCube. When I ran the BEx query in RSRT, I was able to confirm (by looking at the generated SQL) that the query was hitting the aggregate. Yet when I run the APD, there seems to be no improvement in speed. My guess is that the APD is still not using the aggregate.
So my questions are
1. Is there a way to find out whether the APD is hitting the aggregate or not?
2. Is there a way to ensure that the APD does indeed hit the aggregate?