Problems in creating the report to find top 5 long running Queries
I am trying to create a report which should give the result for top 5 long runnings queries for the givin multiprovider or all the multi providers.
I am creating the report on 0TCT_MC01 statistics cube. But it is displaying the result for all queries with all executed times. But i want only top 5. If i include the condition to put top 5, same query is getting if it takes long time.
how can i achieve this.