Report Portal

Large Dimension Processing issue - File system error

A couple of weeks back I experienced an issue with a some what large dimension.  The dimension had around 15.5MM rows and it continued to error while processing the key attribute within the dimension in Analysis Services (SSAS) 2008.  I don’t believe this is a version issue at all and I was able to come up with a solution that resolved the processing issue which I will explain.

What was happening was that all of the other attribute hierarchies were processing fine, but every time the key attribute was being processed it would continue to error out in the same spot (around  60K rows) and it would return this error message (I swapped out a few names to protect the innocent):

Read more...

Tags: management, processing

 

2007-2015 VidasSoft Systems Inc.