Hello expertos.
Nice to be back again.
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.
Txn Log - Empty CHANGE SET ID
-
- 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
-
- 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
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.
* 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
hiraniha