cancel
Showing results for 
Search instead for 
Did you mean: 

BW Query Performance

Former Member
0 Kudos
47

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

Accepted Solutions (1)

Accepted Solutions (1)

edwin_harpino
Active Contributor
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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.