Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Not Enough storage is available

Author  Topic 

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2010-04-27 : 12:22:36
I am getting the above error when processing a cube(full process) that's been in production for a while. Since we're running Standard edition at the moment I can't partition the cube.

What are some good ways to work around this issue? I have contemplated splitting out the facts from prior years into different cubes. That would work but any reporting that spans over those dates would be broken.



An infinite universe is the ultimate cartesian product.

savior faire
Posting Yak Master

194 Posts

Posted - 2010-04-28 : 09:10:05
You can change settings on all your dimension attributes that are not used in queries and/or user defined hierarchies, by setting the attribute properties for members "AttributeHierarchyOptimizedState" to "NotOptimized"; and the "AttributeHierarchyVisible" to "False".

______________________________________________
Talk sense to a fool and he calls you foolish.
Go to Top of Page
   

- Advertisement -