1. If the cube is a MOLAP cube it stores its own copy of the aggregated
data. You can back up the cube datafiles and use as a new cube.

2.Add the olap cube as a linked server using the MSOLAP OLE DB Provider,
issue an MDX query against the cube using the TSQL OPENQUERY function to
grab the data and select into a new table

HTH
Rob

"Saurabh" <saurabhajmera@hotmail.com> wrote in message
news:000a01c36d6d$e68e3c90$a101280a@phx.gbl...
> I have a cube that is based on a fact table whose records
> are deleted each night and again populated with over
> 200,000 records.
>
> Is it possible that I can retrieve the aggregate cube data
> each night after the above process runs and store that
> data in another table? This way I will have aggregations
> stored in a new table for each day. Can this be done with
> DTS or any other method?
>
> Any help will be appreciated.
>
> Thanks,
> Saurabh