Replication and Synchronization

Post Reply
Jessy
Posts: 38
Joined: Wed Mar 25, 2009 7:35 am
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2003

Replication and Synchronization

Post by Jessy »

Hi all,

I am working with TM1 9.4.1, trying to copy cubes from a remote server(source) to the local server( running as independent process), and synchronize data between the two servers.
It really works well when I copy data model and data point values from the source server, also I can write back to the source server when I modify the data point values and press 'Synchronize All Data'.
Sth strange occurs when I try to modify the dimension structure, e.g. I insert an element into the dimension, the modification will not be reflected in the source server after the synchronization, instead, the data model will be copied from the source server to local server, then the modification in local server is lost :?
I can't figure it out even with the operation guide.
Does anyone have similar experience or do you have any advice?
Waiting for your kind help.
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Replication and Synchronization

Post by Steve Vincent »

I've been playing around with this on 9.0 just this week as it's helping loads with a new build. Personally i wouldn't trust local services as far as i can throw Everest, they just don't always behave the same way as a remote service. I did find out that the destination service needs to be registered with the same admin server the source is running on, otherwise it does some things but not others.

Not sure what "directional" settings you get in 9.4 replication but i've not found a sync one way or another option in 9.0, so i'm not sure why yours would do it from source to destination only. Personally i'd try the same thing on 2 remote services and see if its still doing the same.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Jessy
Posts: 38
Joined: Wed Mar 25, 2009 7:35 am
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2003

Re: Replication and Synchronization

Post by Jessy »

It's really kind of you, Steve
Steve Vincent wrote: Not sure what "directional" settings you get in 9.4 replication but i've not found a sync one way or another option in 9.0, so i'm not sure why yours would do it from source to destination only. Personally i'd try the same thing on 2 remote services and see if its still doing the same.
I tried replication in 9.0 SP2 and failed again :(
It still copy data model from source to destination only,even if I modified the dimension in source server first.

I remember it is recorded in the operation guide as follows:
IBM® Cognos® TM1 Operations Guide wrote: TM1 also updates the replicated dimensions if you made changes to their definitions and rules.
IBM® Cognos® TM1 Operations Guide wrote: If there is an update conflict for a particular cell, TM1 uses the most recent update, no matter where this update was made (that is, in the source cube or the mirror cube).
I'm confused
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Replication and Synchronization

Post by Steve Vincent »

not got a chance today but i need to do more with my replications at soem point. I'll test this at the same time and let you know.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: Replication and Synchronization

Post by mattgoff »

Jessy wrote:Sth strange occurs when I try to modify the dimension structure, e.g. I insert an element into the dimension, the modification will not be reflected in the source server after the synchronization, instead, the data model will be copied from the source server to local server, then the modification in local server is lost :?
Is your replication account on the star an admin? I haven't used local servers much, but that's the only thing I can think that might cause this.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
Jessy
Posts: 38
Joined: Wed Mar 25, 2009 7:35 am
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2003

Re: Replication and Synchronization

Post by Jessy »

mattgoff wrote:
Is your replication account on the star an admin? I haven't used local servers much, but that's the only thing I can think that might cause this.

Matt
both accounts are admin, and both servers are running as a remote server

It still doesn't work
Post Reply