Any risk to copy Cell Annotation values ?

Post Reply
BobMilli
Posts: 8
Joined: Thu Feb 28, 2013 9:45 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Any risk to copy Cell Annotation values ?

Post by BobMilli » Fri Jun 21, 2019 9:28 am

Hi,
We've got a business need which is to initialize Cell Annotation from a Budget phase to another and we were planning to script a TI process which will go through all the }CellAnnotations* cubes a do a basic copy (CellPutS) and we were wondering if there was any kind of risk as in the comment you find :
  • the cell location
    a kind of uniqueID
Thanks for your help !
Regards,
Bob

Drg
Posts: 117
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Any risk to copy Cell Annotation values ?

Post by Drg » Thu Jul 04, 2019 6:28 am

from experience I will say that CELLPUTS uses the Trim function for Value, so if your comments start / end with separator characters, then there is a big chance to get something that you did not expect.
Otherwise, this is a regular cube with strings.

Paul Segal
Community Contributor
Posts: 257
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Any risk to copy Cell Annotation values ?

Post by Paul Segal » Thu Jul 04, 2019 10:21 am

So, just to hijack this thread for a moment, I'm trying to figure out a way of making comment practical.. As an example, I have a cube with exchange rates, among other dimensions, and users can put a comment (annotation, would be nice if IBM could make up their mind) against any of the exchange rate elements. In practice, this comment should be against all the exchange rate elements as the rate isn't the significant thing. Problem is the user could comment against any of them, so I think this rules out a rule, but then a TI will need to be fired somehow. Am I making this more complicated than it is, or has anyone else tried to solve this problem?
Paul

Post Reply