TM1 Forum

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

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

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