How to make an APD use InfoCube aggregates

[former_member185132]

Hi,

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?

Regards,

Suhas

[Former Member]

Hiii,

Try to hard code the period and execute the APD for each fiscal period or calmonth.

This will reduce the processing time and execution would be faster.

eg: try loading data month wise by using query input prompt optional and hard code in apd.

Regards,

Akshay

[Former Member]

Strange, How much Query execution time taken in RSRT

[Former Member]

Check Query input variable is it Mandatory or Optional.

It should be optional with fix parameters.

Regards,

Sushant

[former_member185132]

Hi Sushant,

The variable is optional, and it has been filled up in a query variant. The APD uses the query variant, which provides the value for the variable.

Regards,

Suhas