Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ABHISEK.K.S
Starting Member
3 Posts |
 Posted - 2011-03-25 : 05:53:06
|
| 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--------------------------------------------------------Thanks for u reply.I dont want to synchronise the analysis services database. An example cube (Name-Test data model) having one dimension and only one fact.This cube built in a server and 2 local test server. 1 st local server dimensions table having different data and 2 nd local server having different dimensions data . I need to pull all those data to main server. The thing is, i Dont need to do manually, while executing the cube in localserver , data's automatically need to go main server.how? ABHISEK |
|
|
|
|
|
Replication of multiple cubes data to one cube