Replication of cubes from one server to another

Question

Replication of cubes from one server to another

brainblower13

Right there with Babe

Points: 719
More actions
March 23, 2011 at 12:10 am

#247315

Hi,
I need to replicate the cube from one server to another.Two server having same dimension and fact table .Same Dimension table structure and measures of fact tables is there, without data in another server also. When i process the cube in first server, data need to add in both first and second server. How to do that.
Thanks in advance

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

you could use SSIS to deploy them same xmla cube code, to both servers and then set this up as a job that you can execute to process the cube to two servers.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Another option is to use the Synchronize wizard in the SSAS server.

http://msdn.microsoft.com/en-us/library/ms174928(v=SQL.105).aspx

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

brainblower13 Right there with Babe Points: 719 More actions · Answer 3

Hi,

Thanks For ur replies..

Synchronise SSAS wizard Is used to synchronise the complete SSAS database. Here , 1st Test-server having cube named (Test-Model) which contains dimensions and fact tables. The same named cube , built with same dimensions and fact of 2 nd test server. First server contains different data , second test server contains different data. Main Server (3 rd one) also having same named cube with same dimensions and fact tables.. while executing the daily sql server job in first and second server cube , data's of the first and second server are need to come in main server cube for the same dimensions and fact tables.

Is it possible in SSAS. Here we need to avoid ssis packages as some one mentioned in the before replies. We need simple process and also we need to know any built in function is there or not????????

ANy one help me.....

Thanks in advance

ABHISEK.K.S

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 4

Here are the different deployment methods for SSAS:

http://msdn.microsoft.com/en-us/library/ms175446(v=sql.90).aspx+

Choose the one with suits your requirements the most.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

steveb. SSC-Forever Points: 46733 More actions · Answer 5

As mentioned there are many options , I wouldn't discount the SSIS package for being too complex it can be fairly straight fowared to setup

brainblower13 Right there with Babe Points: 719 More actions · Answer 6

Hi,

Is it possible to synchronise the particular cube in a SSAS database?.I Dont want to synchronise the whole database, i am having 5 cubes in a database , i need to synchronise only 3 rd cube. Whatever articles i read and sent by before replies cant found answer for this.... All articles and links sent by before replies are only for synchronizing the database....

Thanks in advance