Txn Log - Empty CHANGE SET ID

Post Reply
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Txn Log - Empty CHANGE SET ID

Post by bunchukokoy »

Hello expertos.

Nice to be back again. :D

May I just ask what is the difference between the CHANGE SET ID having a value and having none (blank/null)? What do they mean ?
Does it tell if the transaction was done manually (by user inputting thru cube view) or done by a TI ( which the user triggered) ?

Thanks a lot. Merry Xmas. Happy Zombies.
hiraniha
Posts: 17
Joined: Thu Jul 05, 2012 3:27 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010

Re: Txn Log - Empty CHANGE SET ID

Post by hiraniha »

I was after the same information, so I have done some digging around and this is what I have discovered, may not be all the situations

* A manual change either via the cube viewer or Excel sheet with DBR/DBRW formuales creates a SET ID, I assume to support the Undo capability
* An update in a TI using either CELLPUTN or CELLPUTS doesn't have a SET ID
* An update via a DB Send (DBS) doesn't have a SET ID

So my conclusion so far is that the SET ID may be there to support the Undo capability.
regards

hiraniha
Post Reply