dbTalk Databases Forums  

Programmatically save a cube as a different cube

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Programmatically save a cube as a different cube in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Devin McMahon
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.