BW Query Performance

[Former Member]

Hi all,

I have a BW query with awful runtime performance.

Analyzing the BW Statistics with query 0BWTC_C10_Q014, I show the problem is on DBTIME Kfigure.

How can I optimize the DBTIME?

Please help me.

Thanks.

Claudia

[edwin_harpino · Accepted solution]

hi Claudia,

query from infocube ? you can create aggregate on that cube

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3f66ba90-0201-0010-ac8d-b61d8fd9...

hope this helps.

[Former Member]

Hi Claudia,

if DBTime is the problem and less than 30% of the selected records will be transferred, then an aggregate will be helpfull. Execute and debug the query in RSRT, check select aggregates and aggregates found. System will show you on next screen which infoobjects should be in an aggregate and with fixed values or hierarchies. You can also use filter and rows characterisitics and resytrictions in keyfigures of your query to get an idea of your aggregate.

You can also try to propose aggregates from last run.

But you may can use compression to reduce the data size of the cube on database. Other alternative, you may delete data which is not needed any longer (maybe all data older than 2 years).

Hope you get an idea.

Regards

Juergen

[edwin_harpino]

hi Claudia,

query from infocube ? you can create aggregate on that cube to reduce dbtime

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3f66ba90-0201-0010-ac8d-b61d8fd9...

hope this helps.