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.
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. |
 |
|
|
|
|