Cell Annotation

Post Reply
MarenC
Posts: 82
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 » Tue May 12, 2020 12:33 pm

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: 2425
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Cell Annotation

Post by Wim Gielis » Tue May 19, 2020 7:11 am

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

MarenC
Posts: 82
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 » Tue May 19, 2020 9:38 am

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