I deployed a new AS solution to our production environment.  When I go to browse the cube (using any tool...BIDS, SSMS, Excel 07) however it takes for ever for it to open to browser window (15 minutes or more).  I know this is a pretty open question but any ideas why?

We have data loaded for all of 2009 through the current date of 2010.  My main Fact table contains roughly 650 million rows (use of partitions at about 12 to 19 million rows each) but my issue is just opening the browser right now. When the browser finally does open I have to wait just as long just to expand a dimension.  At this point 30+ minutes have past and I've done nothing but open the browser and expand a smaller dimension to see it's contents (hierarchies and attributes). 

Any ideas?

Still working on this issue.

Our sql fact table was partition and compressed.  We eliminated that and had no connection errors until we loaded another day of data and processed the AS solution and now we're back to square one.  It takes anywhere from 15 to 30 minutes from the time you right-click the cube in SSMS and select browse before the cube opens.  I did have a distinct count measure group in the AS solution that was large.  I eliminated it and it still made no change. 

If anyone has experienced this and has any suggestions I would greatly appreciate a reply.  Thank you.

Hi,

Have you checked the CPU, memory, and Disk I/O Metrics on the server using Task Manager or Performance Monitor? 

You may override the default member with NULL and see if that speeds up your initial connection

CREATE MEMBER CurrentCube.[MEASURES].NullMember AS null, VISIBLE = 0;

ALTER CUBE CurrentCube UPDATE DIMENSION Measures, DEFAULT_MEMBER=[MEASURES].NullMember;

Then run the Profiler to see what its do in SSAS

A good resource is

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc

Regards,

Luke