Hi there!

I need to address a problem that I'm having while processing a Cube
on MS Analysis Services, which is as follows:
I've designed a Data Cube with ROLAP processing (this, due to the
use that the cube will have: accessing historical data). While
processing, I get the following error:
'There is insufficient result space to convert a money value to small
value'.
When this error occurs, the Processing Status is inserting a table into

the cube that includes the aggregate function SUM on columns that have
smallmoney as data type. So, I've decided to convert, in every column
of my Database (the DataSource for the Cube), all columns with
smallmoney datatype to money data type. I also have free up space on my

drives to address this issue, but nothing seems to work.


Plz, I would appreciate any comments you can make on this error:
possibles reasons for this error to happen, and hints on how to solve
it.


Thankx a lot.


-Sergio Eliot.