How to find SQL Traces in ST05

When i was working with Performance issues on BEx queries we face so many issues.

While coming  we created BEx reports for dashboard requirement and always users want run the dash board they want immediately.

We made aggregates on cube but again some performance issue came. How do you which object is using frequently then we trace the Dash board BEx queries.

How to find the SQL Trace

1.enter the T- code- STO5

Below screen appear then check the SQL Trace and RFC Trace then select the activate trace with filter – give user name -> USER1.

Select continue

Now see trace activated.

2.Enter the T-code- RSRT

Run the query and it took 8 minutes time

Go to again T-code- ST05

Deactivate the Trace now trace are switched off

Then select the display trace

Then next screen will appear

Filter the object name was Info cube E face table

Double click on the SQL select statement

Below screen will appear

In SELECT statement how many object are using we find easily (for information i am erasing the using all info object) then we made aggregates based on the SQL script.

After making aggregates on cube our dash board report came within 2 minutes.