OLAP Cubes and Programming

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Devin McMahon
    #1

    OLAP Cubes and Programming

    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 programmaticall y save a cube
    to a different name with some type of automation object?

    Thanks
    Tags: None
    • Simon Hayes
      #2
      Re: OLAP Cubes and Programming

      I don't have an answer, but the following newsgroups are more specific to
      this area:

      microsoft.publi c.sqlserver.ola p
      microsoft.publi c.sqlserver.dat awarehouse

      Simon

      "Devin McMahon" <dmcmaho1@twcny .rr.com> wrote in message
      news:10ef789a.0 307070741.78fe5 349@posting.goo gle.com...[color=blue]
      > 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 programmaticall y save a cube
      > to a different name with some type of automation object?
      >
      > Thanks[/color]


        Comment

        Previous template Next
        Working...