March 31, 2009 at 8:00 am
I have an OLAP cube in SQL Server Analysis Services 2005, this consists of 7 Dimensions and 6 Measures. This is on a Windows 2003 R2 64 bit server with 48GB ram. Excel 2007 is also installed on this server and I am using this to connect to the cube to create a Pivot Table report.
The report I am trying to create consists of two Dimensions, one Time dimension filtered to one year, 2007, and one Attribute dimension containing 11 Attributes. When I add these into the Pivot Table Row Column area after a few minutes Excel crashes out with out of available resources error. Task Manger shows Excel using 1.7GB of ram and 1.7GB of VM. The cube is 39MB in size and has 6000 fact table rows.
There appears to be a memory limit in Excel Pivot Table engine that is stopping this from working, has anybody come across this? Any ideas?
April 2, 2009 at 8:24 am
The link below may give some insight to memory usage by Excel 2007.
http://www.decisionmodels.com/memlimitsc.htm
Have you tried to connect to your data from another workstation and running the process?
Can you try the process using Excel 2003 and get the same results?
I have started using SSAS 2005 and Excel 2003/2007 to report cube data and haven't had that issue but I don't run Excel on the server either.
😎 - not an expert, just a user...
For help on getting help, follow the link below:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply