how can i move cube to another olap database without lose the data?

10X,
Chai

Does the cube have private or shared dimensions?

I believe this could be done if it uses private dimensions. And if it does
use shared dimensions, the shared dimensions dont have the same name as any
dimensions in the target database.

Here's how I'd do it:

1. Copy the cube and associated dimensions (metadata) over to the new OLAP
database through Analysis Manager (right click copy/paste)
2. Take the service down
3. Copy the associated cube and dimensional data files over to the new
folder
4. Bring service back up

That should work.





"Chai" <Chai (AT) discussions (DOT) microsoft.com> wrote

i have shared dimension but , i already have those dim in my target olap db.
can it work?

"Jesse O." wrote:

nope, you'll have to reprocess if you want to use the existing dimensions


"Chai" <Chai (AT) discussions (DOT) microsoft.com> wrote