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
Copy cell level comments from old to new cube
-
- Posts: 20
- Joined: Mon Sep 16, 2019 12:17 am
- OLAP Product: TM1 Planning Analytics
- Version: 2.0
- Excel Version: 2019
Copy cell level comments from old to new cube
- Attachments
-
- Comments.png (101.53 KiB) Viewed 2581 times
- orlando
- Community Contributor
- Posts: 167
- Joined: Fri Aug 04, 2017 8:27 am
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365
Re: Copy cell level comments from old to new cube
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
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
-
- Posts: 20
- Joined: Mon Sep 16, 2019 12:17 am
- OLAP Product: TM1 Planning Analytics
- Version: 2.0
- Excel Version: 2019
Re: Copy cell level comments from old to new cube
Thanks Orlando, that works.
Very much appreciated.
W
Very much appreciated.
W