What is the size of the Analysis Services Database? try to query using MDX by limiting the no. of records you want to see