Page 1 of 1

Copy cell level comments from old to new cube

Posted: Mon Sep 30, 2019 5:32 am
by WayneBo
Hi all:

I have an occupancy cube to tracking daily occupancy with users putting comments everyday in the cell level.

Then, I have built a replicate of the occupancy cube with better time dimension ( rest dimension the same as the old one).

I have migrated data from old cube to new cube via TI process with cellputs and cellputn.

But now, for those comments in the cell level from old cube, how do I migrate those to the new cube?, could anyone please advise,
Please see screenshot below.

Thanks
Image

Re: Copy cell level comments from old to new cube

Posted: Mon Sep 30, 2019 8:39 am
by orlando
Hi,

these comments are stored in an extra cube "}CellAnnotations_YourCubeName"

Your new cube needs also these cube (easiest way to create: make a comment ;-) )

If you have it you can try to copy the values into the new copy - never done that myself.

I see one problem:
in the values, stored in the annotationsCube the Cubename is referred:

.... ,"objectName":"YourCubeName"}

I think you have to replace it with the new cube name.

and you have to make sure, that the dimension order of you new cube is absolut the same
than the old cube, because all dimensione elments are also referred.

Good luck!

Best regards,
orlando

Re: Copy cell level comments from old to new cube

Posted: Wed Oct 02, 2019 12:09 am
by WayneBo
Thanks Orlando, that works.

Very much appreciated.

W