How to use the T-code RSRT

[#1]

hi

I had to check wether the aggregates Created on the Infocube increases the Query performance or not.

Can any body please help me how to use The T-Code RSRT to check the Query Performance with aggregates and without aggregates.

(please Give me the step by step Sequence)

hanks in Advance

[Former Member · Accepted solution]

hi,

go to rsrt type the query name and use execute and debug option tab to select the various option to anlayze the performance.

regards

pls assign poiints if helpful.

[Former Member]

The speed with which the output displays definitely varies when reported via aggregates. You can compare that using BW statistics. The data is aggregated based aggregate design inturn based on query design. So the data reading time reduces obviously

In transaction RSRT, use 'execute and debug' on your query. In the debug options you can choose not to use aggregates (and cache). So run your query 2 times, with and without using aggregates, using the same selections. In se16, table RSDDSTAT (BW Statistics), you can see the time used for both executions

Go to ST03 transaction and change the mode to expert mode...There will be difference in Total Runtime(Secs) when the report is executed with aggregates and without aggregates

one more option is to go to RSRT and in the execute and debug options - select display statistics data and then run it with aggregates and without aggregates and you can find the difference in access times..