What is the size of data warehouse n How can we write a query at report level for
Finding top10 revenue records?
top10 frm downwards?
what are you using as source for your report? relational or dimensional
if dimensional, i think there is a function Topcount
For relational package use rank and for dimensional package use top count