Cell Annotation

Post Reply
MarenC
Regular Participant
Posts: 350
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Cell Annotation

Post by MarenC »

Hi,

I wanted to create a process to copy comments made in workspace between versions and it was much easier than I imagined it would be.

Basically all I did was create a view of the }CellAnnotations_TestCube and copy the value for the source version into the target version.

When I first looked at the string held in the }CellAnnotations_TestCube I imagined I would have to alter the text value to reference the new version, but I can get away with just a copy and paste.

My question is, why can I get away with this and what is the text string for if it doesn't drive the dimensionality?

An example of the string is below (I imagined I would have had to loop through this string replacing SourceVersion with whatever the target version was):
[{"caption":"Test Comment Workspace!",
"creator":"Admin",
"id":"xxxx-xx_xx",
"properties":{"cellValue":"09",
"commentLocation":"SourceVersion,Employee,Period",
"commentType":"ANNOTATION",
"commentValue":"Test Comment Workspace!",
"objectName":"TestCube"},
"timeCreated":"20200512121715"}]
Maren
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cell Annotation

Post by Wim Gielis »

So you basically did CellPutS in the target with a variable like SValue ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
MarenC
Regular Participant
Posts: 350
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Cell Annotation

Post by MarenC »

Hi Wim,

Yes, a cellputs to the target version.

I was expecting that I would have had to manipulate the string somehow to replace the source version with the target version, but to my surprise it simply worked by doing a cellputs without me having to alter anything.

Maren
Post Reply