On Parallel Interaction 9.5.2

Post Reply
hyd_ladka
Posts: 8
Joined: Fri Aug 19, 2011 5:46 am
OLAP Product: cognos tm1
Version: 9.5.2 10.1
Excel Version: 2003 2007 2010
Location: India

On Parallel Interaction 9.5.2

Post by hyd_ladka »

Hi,

I am new to TM1. Was working on 9.5.1 so far. I have been recently going through the doc. of 9.5.2.
On Parallel Interaction, it says "Parallel Interaction addresses this issue by enabling the TM1 server to automatically manage multiple versions of only the modified data in a cube, allowing read and write operations to execute at essentially the same time"
I have a question here. What if two/more users write/edit the same value in a cell at the same time? Which value would it then take? Please correct me if my understanding is wrong here.
I have searched this forum before for the same question but i wasn't able to get hold of any solution.

Regards,
chand
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: On Parallel Interaction 9.5.2

Post by lotsaram »

hyd_ladka wrote:What if two/more users write/edit the same value in a cell at the same time? Which value would it then take?
Simple answer: last update wins. Why would you expect anything different?

To qualify this though it is the last update at the point in time the data is committed not necessarily when the update was commenced from the user point of view. Say you had a large and long running data spread. In the meantime another user could get in and make a small point update withing the region to which the spread was being applied and this change would be applied to the main model. However when the spread finished and was committed then this would overwrite the interim values that had previously been committed by the other user.

On the whole this seems sensible to me. I don't see how they could have designed it any differently.
hyd_ladka
Posts: 8
Joined: Fri Aug 19, 2011 5:46 am
OLAP Product: cognos tm1
Version: 9.5.2 10.1
Excel Version: 2003 2007 2010
Location: India

Re: On Parallel Interaction 9.5.2

Post by hyd_ladka »

Okay.
Got it. Thanks!
Now, will a user be able to know or identify if someone else is trying to change/modify any value on which he is working?
I don't think so. am i right?
Thanks again!
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: On Parallel Interaction 9.5.2

Post by qml »

hyd_ladka wrote:Now, will a user be able to know or identify if someone else is trying to change/modify any value on which he is working?
I don't think so. am i right?
You are indeed right. However, you can always design the model so that it prevents this or at least reduces the chance of this happening by applying any combination of the following solutions:
- workflow control,
- security,
- the Reserve functionality,
- multiple input cubes,
- etc.
Kamil Arendt
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: On Parallel Interaction 9.5.2

Post by mattgoff »

lotsaram wrote:On the whole this seems sensible to me. I don't see how they could have designed it any differently.
The solution, difficult as it might be to implement, is how Bugzilla handles it. If your write includes a cell which has changed since you last read it, you get a warning. You can still proceed to overwrite the other user's commit, but at least you get an FYI.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
Post Reply