Re: Issue with Migrating OLAP Cube

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 08/28/04

  • Next message: psmith28: "Rollup problems"
    Date: Fri, 27 Aug 2004 17:44:58 -0700
    
    

    See the section titled "Release Management" in the Analysis Services
    Operations Guide.
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
    It might have some material to assist this activity. Notably the discussion
    of (and pointer to) the DSO/XML utility.

    -- 
    Dave Wickert [MSFT]
    dwickert@online.microsoft.com
    Program Manager
    BI SystemsTeam
    SQL BI Product Unit (Analysis Services)
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.
    "Steven Wong" <anonymous@discussions.microsoft.com> wrote in message
    news:0ac801c48c47$02aa2c10$a401280a@phx.gbl...
    > I am getting this error message when copy/paste cubes from
    > OLAP Server Dev to OLAP Server UAT:
    >
    > "Could not paste cube 'CUBENAME'.  The target database has
    > a data source, 'SERVERNAME - APPL_NAME', that has the same
    > name as the data source for the source cube, but some
    > connection string properties are different.  Each data
    > source used in a database must have a unique name within
    > the database."
    >
    > How else would I be able to migrate OLAP cubes I have
    > created in my OLAP Dev Server to my OLAP UAT Server?
    > Please don't tell me I have to re-create each cube in the
    > OLAP UAT Server!
    >
    > Currently, both servers have Analysis Services 2000 are
    > installed.
    >
    > PLS HELP!
    >
    >
    

  • Next message: psmith28: "Rollup problems"

    Relevant Pages

    • Re: OLAP cube build stuck (Project 2003 Server)
      ... It looks like the OLAP build just died. ... I'm thinking a Project Server ... Concerning the admin permissions needed to build the cube: ...
      (microsoft.public.project.pro_and_server)
    • Re: how do I load a cube?
      ... sql 2005 analysis services but there is no option to load a cube. ... New to analysis server. ...
      (microsoft.public.sqlserver.olap)
    • Re: OLAP cube build stuck (Project 2003 Server)
      ... cube will probably be enough - if not, ... Have you migrated the OLAP metadata repository to an sqlserver database ... identity used for communicating with the OLAP server a member of the OLAP ... I have installed SQL AS, ...
      (microsoft.public.project.pro_and_server)
    • Re: how do I load a cube?
      ... sql 2005 analysis services but there is no option to load a cube. ... New to analysis server. ...
      (microsoft.public.sqlserver.olap)
    • Having trouble getting started...
      ... I need some help getting started with Analysis Services. ... using Windows 2003 Small Business Server, with SQL Server 2000, not sure ... I am able to connect to the analysis manager with no problems. ... The cube-browser error says 'Unable to connect to cube: ...
      (microsoft.public.sqlserver.olap)