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.

Thanks,
Saurabh
 
 
 

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.

--
-Euan

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.