Transferring cube data to a table

Transferring cube data to a table

Post by Saurab » Fri, 29 Aug 2003 23:09:39

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.


Transferring cube data to a table

Post by Euan Garde » Sat, 30 Aug 2003 10:15:30

If you use DTS with the OLE DB provider for Analysis Services as a source
this should be possible.


Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.

This posting is provided "AS IS" with no warranties, and confers no rights.