Re: Issue with Migrating OLAP Cube

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

Date: Fri, 3 Sep 2004 11:40:07 -0700

Sorry. I have no idea.
It appears to be working properly on the test scenerios.
You might consider openning up a PSS case as what you are doing *should* be
working properly from the description you've given so far. 

-- 
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:002c01c491d3$18d0ca80$a401280a@phx.gbl...
> I tried your scenario and it works fine.  My real scenario
> differs from your scenario in that: 1) The AS database
> NAME and data source NAME are the same in dev server and
> uat server, but the underlying SQL database differs.  2)
> Copy/pasting in 2 diff servers.
>
> I tried your #2 using my AS dbname1 on my dev machine.  I
> copy/pasted a new AS dbname2 (obviously, need a new name)
> into the same dev server, then, deleted a couple of cubes
> from the AS dbname2.  Then, I copy those same cubes from
> the AS dbname1 and pasted them into AS dbname2, and they
> work fine.
>
> Any further thoughts why it still won't work in my real
> scenario?
>
> >-----Original Message-----
> >Hmmm..
> >
> >So I did the following to try and reproduce the problem.
> >I cut and pasted Foodmart 2000 to Foodmart 2000 Test.
> >In Foodmart 2000 Test, I deleted the HR cube and all of
> the mining
> >models/dimensions.
> >I processed the database. Everything processed clean.
> >Now the only difference between Foodmart 2000 and
> Foodmart 2000 Test is that
> >the HR cube is missing in Foodmart 2000 Test.
> >
> >I then cut & pasted the HR cube from Foodmart 2000 to
> Foodmart 2000 Test.
> >Everything went OK and then I could process the HR cube
> without any
> >problems.
> >
> >How is that different from your scenerio? Anything
> different?
> >The only thing that I can think of is that it is on the
> same machine.
> >
> >1) can you try the above and see if the same thing
> happens on your machine
> >2) can you try your scenerio but have both databases be
> on the same machine
> >
> >-- 
> >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:547c01c49145$67030a80$a301280a@phx.gbl...
> >>
> >>
> >> When I say "move", I was trying to copy/paste the new
> >> cubes from dev Analysis Services (AS) server to UAT AS
> >> server.  Both data source names are the same in both AS
> >> server except they are pointed to its own respective
> >> underlying SQL database.
> >>
> >> Did that help?
> >>
> >>
> >> >-----Original Message-----
> >> >Can you be more specific? When you say "move" your cube
> >> from dev to
> >> >production, what do you mean? What technique are you
> >> using?
> >> >-- 
> >> >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:4f8201c49111$6605bc60$a501280a@phx.gbl...
> >> >> Hi Dave:
> >> >>
> >> >> The articles do not address migration of new OLAP
> cubes
> >> >> between existing AS databases.
> >> >>
> >> >> I need to move the new OLAP cubes from my dev AS
> >> database
> >> >> over to my UAT AS database, but is getting this
> >> >> message "The target database has a data source name
> that
> >> >> has the same name as the datasource for the source
> >> >> cube..." when I copy the new OLAP cube over.
> >> >>
> >> >> It seems like the following are my only options:
> >> >> 1) Delete the AS database on UAT server, and recover
> an
> >> >> archive copy of the AS database from dev server with
> all
> >> >> the new OLAP cubes on the UAT server.
> >> >> 2) Manually re-create all the new OLAP cubes on my
> UAT
> >> >> server. (Would hate to it over when migrate to
> >> production!)
> >> >>
> >> >> Does Microsoft has any other options?  Any advice
> will
> >> be
> >> >> very much appreciated.
> >> >>
> >> >> Thanks in advance.
> >> >>
> >> >>
> >> >> >-----Original Message-----
> >> >> >See the section titled "Release Management" in the
> >> >> Analysis Services
> >> >> >Operations Guide.
> >> >>
> >>
> >http://www.microsoft.com/technet/prodtechnol/sql/2000/main
> >> >> tain/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.
> >> >> >
> >> >> >"Prasanna" <prasanna_b2001@yahoo.com> wrote in
> message
> >> >>
> >news:bcfe7189.0408300744.34b30cb7@posting.google.com...
> >> >> >> Hi All,
> >> >> >> I have cubes in my local machine. Now I need to
> >> >> replicate them in the
> >> >> >> production server which is a remote machine.
> Please
> >> >> tell me how to
> >> >> >> copy the
> >> >> >> OLAP cube from my machine to the production
> machine.
> >> >> Please give me
> >> >> >> the steps to do that.
> >> >> >>
> >> >> >> Thanks in Advance
> >> >> >> Prasanna
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: What is your database application development environment?
    ... development, then switch to the Test or QA database for optimization, ... both our Dev and QA processes used smaller databases. ... have DEV boxes or CPU cycles that closely resemble QA and production. ... each running SQL Server Developer. ...
    (borland.public.delphi.non-technical)
  • Re: Ideal Web Development Environment?
    ... only developer in a 1 server department with no budget, few resources, ... sandboxed area of the dev box. ... php, database, third party tools, onto your own computer (which could ... Config Files: There have to be many types of config files. ...
    (comp.lang.php)
  • Re: DISCOVER_XML_METADATA
    ... expansion of ASSL XML returned by the server. ... You could do ExpandObject for the server in step 1. ... you could request ExpandObject for that database -- this is step ... all cubes and nothing else. ...
    (microsoft.public.sqlserver.olap)
  • Re: Issue with Migrating OLAP Cube
    ... I tried your scenario and it works fine. ... uat server, but the underlying SQL database differs. ... I copy those same cubes from ...
    (microsoft.public.sqlserver.olap)
  • Re: Approach for hosting multiple business units on the same server
    ... The easiest way to do this, is to create another Virtual Server in IIS ... With regards to the OLAP cubes - i am not sure how you can limit them to use ... > 2.0) while the second box hosts SQL Server database. ... > I created sites for each business unit using the SiteEdit utility ( ...
    (microsoft.public.project.pro_and_server)