TM1 Forum

Hallo All,

PAW Cell Comments are possible(the information is stored in a control cube called }CellAnnotations_CUBENAME).

I was also looking at this thread (viewtopic.php?p=7320), but still missing what I am after.


I want owners of certain dashboards be able to give comments, imagine a dashboard with personal data on it for a certain month, showing FTE, illness rate, overtime rate for a certain department.

Then the head of the department can give comments to this 'slide'.

For example illness rate april 2020 is high 34%, what is happening?
He could add a comment on that dashboard (name + time stamp) of that month in that department that Corona hits to workfloor hard.

So whenever you select april 2020, for department x, looking at the HR dashboard, you would see that comment.
When you move to may 2020, no comments on that screen.
If you would look at 2020, the comment will appear that for April a comment was added.

Hope this makes sense...

Would you not just need to add string measures to your measures dimension to store these items?

p.s. Depending on your cube/model there are best practice recommendations to keep numerics in one cube and strings in another.
Saying this, would be tricky to present in a grid as a dashboard though in PAW. A Websheet may solve though.

I'm in the 'second cube with comments' (potentially with some cut-down dimensionality) camp. You can try to show it as a cube view with synchronised context or a wesbhreet (that's the standard). Throw in an additional dimension to capture multilines or replies if you're feeling fancy

Note that in PAW that string cells can not be word-wrapped. This pretty much pushes you into a websheet for presentation of comments in many situations.

This has been previously raised and rejected in the RFE portal.

Ok thanks all for your replies, i'll further investigate on the websheets.