Issue with aggregates

[#1]

I am running into issue with performance on our query runs. I have tried creating aggregates..however based on how our queries are written(we are bringing back a whole bunch of data involving navigational attributes), I cannot get any of the queries to hit the aggregates. The only time I have had any kind of success is when I have my aggregates defined explicitly to include all the characteristics that are included in the query. We are dealing with about 5 million records in 0bpartner(the queries are brining back several navigational attributes for 0bpartner in addition to some other characteristics) and also have hierarchy based reporting....other than with using aggregates, what other ways can I try and speed up query performance...any tips or tricks that you folks can provide is much appreciated. Thanks

Dinesh

[Former Member]

Hi,

First of all you need to find out wherey your query is taking time.

Is it at database level/OLAP time or frontend time

u can check it using following tools

use RSRT,RSRV,st05...

accordingly we can proceed to enhance the query perofmance

Cheers,

Swapna.G