Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

In order to do this, for the cube where Cell Annotations are stored, I have created another cube (with one additional dimension line_item, and a measures dimension with following elements:

• User Name
• User Comment
• Timestamp
• Cell Value

Then I have created a TI Process that will read the }CellAnnotations_ cube and populate the measures above from JSON string

Then I have created Drill Processes and Drill Rules to consolidate/show the comments entered in a cell or in Consolidated Cells (for example: If there is a Hierarchy on a Call Centre dimension, and the comments are entered in Leaf Cost Centres, if the user Drills from a Consolidated Cost Center, the Drill Process will show all comments entered in the Leafs under the selected consolidation)





------------------------------
Ardian Alikaj
------------------------------

Original Message:
Sent: Wed October 26, 2022 01:12 PM
From: Asgeir Thorgeirsson
Subject: View CellAnnotations

Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

Thank you @Ardian Alikaj
I will check this out.

Can you please share some of the code in the TI process for parsing the annotation.

Cheers, Asgeir
​​

------------------------------
Asgeir Thorgeirsson
------------------------------

Original Message:
Sent: Wed October 26, 2022 01:37 PM
From: Ardian Alikaj
Subject: View CellAnnotations

In order to do this, for the cube where Cell Annotations are stored, I have created another cube (with one additional dimension line_item, and a measures dimension with following elements:

• User Name
• User Comment
• Timestamp
• Cell Value

Then I have created a TI Process that will read the }CellAnnotations_ cube and populate the measures above from JSON string

Then I have created Drill Processes and Drill Rules to consolidate/show the comments entered in a cell or in Consolidated Cells (for example: If there is a Hierarchy on a Call Centre dimension, and the comments are entered in Leaf Cost Centres, if the user Drills from a Consolidated Cost Center, the Drill Process will show all comments entered in the Leafs under the selected consolidation)





------------------------------
Ardian Alikaj

Original Message:
Sent: Wed October 26, 2022 01:12 PM
From: Asgeir Thorgeirsson
Subject: View CellAnnotations

Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

Hi Asgeir,

Just a heads up, the annotations cubes are 'internal', there is no guarantee that what's stored in them doesn't change over time, nor do you have access to the files that might store the actual annotations if the size of all the annotations associated with a cell are larger then what can be contained in a TM1 string stored in a cube (65.000 bytes). 
The best way to get all the annotations would be to use the REST API and simply retrieve them using the <<service-root-url>>/Cubes('CubeName')/Annotations.

Cheers, -H

------------------------------
Hubert Heijkers
------------------------------

Original Message:
Sent: Wed October 26, 2022 01:12 PM
From: Asgeir Thorgeirsson
Subject: View CellAnnotations

Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

An additional note about annotations and performance to keep in mind. There is an open issue, "PH49510 TOTAL NUMBER OF CELL ANNOTATIONS SLOWS DOWN API RESPONSE TIME WHEN RETRIEVING THE COMMENTS IN PLANNING ANALYTICS WORKSPACE." The annotation end point to get 1 annotation doesn't scale well and instead slows down as the total number of annotation increases.

------------------------------
Ryan Clapp
------------------------------

Original Message:
Sent: Thu October 27, 2022 07:21 AM
From: Hubert Heijkers
Subject: View CellAnnotations

Hi Asgeir,

Just a heads up, the annotations cubes are 'internal', there is no guarantee that what's stored in them doesn't change over time, nor do you have access to the files that might store the actual annotations if the size of all the annotations associated with a cell are larger then what can be contained in a TM1 string stored in a cube (65.000 bytes). 
The best way to get all the annotations would be to use the REST API and simply retrieve them using the <<service-root-url>>/Cubes('CubeName')/Annotations.

Cheers, -H

------------------------------
Hubert Heijkers

Original Message:
Sent: Wed October 26, 2022 01:12 PM
From: Asgeir Thorgeirsson
Subject: View CellAnnotations

Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

Painfully aware Ryan, combination of missing functionality in the REST API and organizational breakdown, we'll get that improved (technically nothing is broken but the way those one annotations are being retrieved... I don't know a slower way to do it even if I wanted to;-).

But that doesn't change the fact that retrieving annotations through the REST API, in essence, would be the best way to go, especially if more then one annotation exists in/for a cell, let alone changes are being made in a sandbox in which case the value kept in the sandbox describes the 'patch' to the original value and one would need to apply 'merge' logic to get the [set of] annotations at that point of time for a cell.

At the same time I understand that this might not help you get those annotations in a different way in PAW so perhaps an enhancement request in PAW would be warranted here.

------------------------------
Hubert Heijkers
------------------------------

Original Message:
Sent: Thu October 27, 2022 10:18 AM
From: Ryan Clapp
Subject: View CellAnnotations

An additional note about annotations and performance to keep in mind. There is an open issue, "PH49510 TOTAL NUMBER OF CELL ANNOTATIONS SLOWS DOWN API RESPONSE TIME WHEN RETRIEVING THE COMMENTS IN PLANNING ANALYTICS WORKSPACE." The annotation end point to get 1 annotation doesn't scale well and instead slows down as the total number of annotation increases.

------------------------------
Ryan Clapp

Original Message:
Sent: Thu October 27, 2022 07:21 AM
From: Hubert Heijkers
Subject: View CellAnnotations

Hi Asgeir,

Just a heads up, the annotations cubes are 'internal', there is no guarantee that what's stored in them doesn't change over time, nor do you have access to the files that might store the actual annotations if the size of all the annotations associated with a cell are larger then what can be contained in a TM1 string stored in a cube (65.000 bytes). 
The best way to get all the annotations would be to use the REST API and simply retrieve them using the <<service-root-url>>/Cubes('CubeName')/Annotations.

Cheers, -H

------------------------------
Hubert Heijkers

Original Message:
Sent: Wed October 26, 2022 01:12 PM
From: Asgeir Thorgeirsson
Subject: View CellAnnotations

Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

Hi Hubert , is there a way to turn off the cell annotation if the client does not want to expose it to the users ?

------------------------------
Zameel Arif
------------------------------

Original Message:
Sent: Fri October 28, 2022 04:05 AM
From: Hubert Heijkers
Subject: View CellAnnotations

Painfully aware Ryan, combination of missing functionality in the REST API and organizational breakdown, we'll get that improved (technically nothing is broken but the way those one annotations are being retrieved... I don't know a slower way to do it even if I wanted to;-).

But that doesn't change the fact that retrieving annotations through the REST API, in essence, would be the best way to go, especially if more then one annotation exists in/for a cell, let alone changes are being made in a sandbox in which case the value kept in the sandbox describes the 'patch' to the original value and one would need to apply 'merge' logic to get the [set of] annotations at that point of time for a cell.

At the same time I understand that this might not help you get those annotations in a different way in PAW so perhaps an enhancement request in PAW would be warranted here.

------------------------------
Hubert Heijkers

Original Message:
Sent: Thu October 27, 2022 10:18 AM
From: Ryan Clapp
Subject: View CellAnnotations

An additional note about annotations and performance to keep in mind. There is an open issue, "PH49510 TOTAL NUMBER OF CELL ANNOTATIONS SLOWS DOWN API RESPONSE TIME WHEN RETRIEVING THE COMMENTS IN PLANNING ANALYTICS WORKSPACE." The annotation end point to get 1 annotation doesn't scale well and instead slows down as the total number of annotation increases.

------------------------------
Ryan Clapp

Original Message:
Sent: Thu October 27, 2022 07:21 AM
From: Hubert Heijkers
Subject: View CellAnnotations

Hi Asgeir,

Just a heads up, the annotations cubes are 'internal', there is no guarantee that what's stored in them doesn't change over time, nor do you have access to the files that might store the actual annotations if the size of all the annotations associated with a cell are larger then what can be contained in a TM1 string stored in a cube (65.000 bytes). 
The best way to get all the annotations would be to use the REST API and simply retrieve them using the <<service-root-url>>/Cubes('CubeName')/Annotations.

Cheers, -H

------------------------------
Hubert Heijkers

Original Message:
Sent: Wed October 26, 2022 01:12 PM
From: Asgeir Thorgeirsson
Subject: View CellAnnotations

Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

Define for me 'if the client doesn't want to expose' the annotations? Which client are we talking about here?

Me, being the TM1 guy that I am, is thinking that a client wouldn't ask if cells have annotations to begin with if it doesn't want to do anything with annotations, let alone retrieve annotations for any object/cell right? TM1, read: the database, never 'suppresses' anything assuming the client would want or not want to do something, it presumes the client has control over that and doesn't ask for things it doesn't need/doesn't want to expose.

------------------------------
Hubert Heijkers
STSM, Program Director TM1 Functional Database Technology and OData Evangelist
------------------------------

Original Message:
Sent: Tue May 27, 2025 06:06 PM
From: Zameel Arif
Subject: View CellAnnotations

Hi Hubert , is there a way to turn off the cell annotation if the client does not want to expose it to the users ?

------------------------------
Zameel Arif

Original Message:
Sent: Fri October 28, 2022 04:05 AM
From: Hubert Heijkers
Subject: View CellAnnotations

Painfully aware Ryan, combination of missing functionality in the REST API and organizational breakdown, we'll get that improved (technically nothing is broken but the way those one annotations are being retrieved... I don't know a slower way to do it even if I wanted to;-).

But that doesn't change the fact that retrieving annotations through the REST API, in essence, would be the best way to go, especially if more then one annotation exists in/for a cell, let alone changes are being made in a sandbox in which case the value kept in the sandbox describes the 'patch' to the original value and one would need to apply 'merge' logic to get the [set of] annotations at that point of time for a cell.

At the same time I understand that this might not help you get those annotations in a different way in PAW so perhaps an enhancement request in PAW would be warranted here.

------------------------------
Hubert Heijkers

Original Message:
Sent: Thu October 27, 2022 10:18 AM
From: Ryan Clapp
Subject: View CellAnnotations

An additional note about annotations and performance to keep in mind. There is an open issue, "PH49510 TOTAL NUMBER OF CELL ANNOTATIONS SLOWS DOWN API RESPONSE TIME WHEN RETRIEVING THE COMMENTS IN PLANNING ANALYTICS WORKSPACE." The annotation end point to get 1 annotation doesn't scale well and instead slows down as the total number of annotation increases.

------------------------------
Ryan Clapp

Original Message:
Sent: Thu October 27, 2022 07:21 AM
From: Hubert Heijkers
Subject: View CellAnnotations

Hi Asgeir,

Just a heads up, the annotations cubes are 'internal', there is no guarantee that what's stored in them doesn't change over time, nor do you have access to the files that might store the actual annotations if the size of all the annotations associated with a cell are larger then what can be contained in a TM1 string stored in a cube (65.000 bytes). 
The best way to get all the annotations would be to use the REST API and simply retrieve them using the <<service-root-url>>/Cubes('CubeName')/Annotations.

Cheers, -H

------------------------------
Hubert Heijkers

Original Message:
Sent: Wed October 26, 2022 01:12 PM
From: Asgeir Thorgeirsson
Subject: View CellAnnotations

Hi

PAW users want to view all annotations related to a TM1 cube.

I thought about creating a cube with a measure dimension, splitting the annotation text into user, time and text and the relevant dimensions and use suppress zeros. We know that the annotations are stored in the "}CellAnnotations..." cube.

The annotation data looks something like this
[{"caption":"Testing","creator":"Active Directory/User...","id":"IukICnXcvH","properties":{"cellValue":"1234","commentLocation":"IS,KEF,BOS,Total of All Channels,Current,All Classes,Pax CalcToTarget,202304","commentType":"ANNOTATION","commentValue":"Testing","objectName":"DT_SectorTarget"},"timeCreated":"20221025111146"}]

Has anyone resolved this or similar?
Or is there a plan to have a user-friendly annotation overview built in PAW?

Thanks, Asgeir


------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson