How to schedule to run replication?

juese72

Ok, here is what I have done.
1. Create a replication connection
2. Replicate some cubes and set to sync
3. Create a chore with replication connection
4. Run the chore
5. Successfully but from the log, only subsets and views have been replicated and no change on data

What have I missed?

chenwu521

Ok, after reading the posts inside the forum, I found that "Synchronize All Data" or chore looks at transaction log files in the source (Star) server to check if there are any changes, it will not be able to recognize those data changes that happened through TI Processes that are not recorded in transaction logs. Therefore you will loose the reconciliation of data between Star and Planet servers as you transfer data to Star through TI processes.
Since my cubes on Star doesn't have logging data through TI Processes, it won't apply any data changes on Planet cubes.
But from replicate interface of each cube, TM1 will immediatly replace the cubes and other objects after clicking on OK.
The working mechanism of this is kind of different from "Synchronize All Data".
That is my understanding and please correct me if anything is wrong.

pakyarms

fuanxx

macsir wrote:Since my cubes on Star doesn't have logging data through TI Processes, it won't apply any data changes on Planet cubes.

Normally, people turn logging off because they are loading from a source system, typically ODBC. If your planet servers can access that same source system then you don't need replication. If you've got a mix of budget and actuals and are trying to replicate the budgets to the planets then its a different story. What is driving your need to use replication?

wlx123

rmackenzie wrote:Normally, people turn logging off because they are loading from a source system, typically ODBC. If your planet servers can access that same source system then you don't need replication. If you've got a mix of budget and actuals and are trying to replicate the budgets to the planets then its a different story. What is driving your need to use replication?

I just need to copy some cube's data for some proccess to run in another server. I can do export and import by text file but replication is quick and can sync all dimensions.

dada19891101

To use replication, you have to use the transaction log files.