Programmatically save a cube as a different cube -
07-07-2003
, 10:42 AM
I cannot seem to find a group where this question would
fit so I am posting it here. I have what I believe is a
unique situation. I am using SQL Server Analysis Server
to build a cube of "snapshot" month-end type of data.
This data is from an instance of Microsoft Navision and I
have successfully used SQL-DMO and DTSPackage Library
objects to allow the user to rebuild the cube through
Navision. This is accounting data and as such, the
accountants want to be able to archive this data by
month. I know through Analysis Server Manager interface
I can copy the cube and save it to a different name.
I would like to know if there is a way to
programmatically save a cube to a different name with
some type of automation object?
Thanks |