Comments and threaded conversations in dashboards

Post Reply
hansTM1
Posts: 2
Joined: Wed Mar 11, 2020 2:31 pm
OLAP Product: TM1
Version: IBM Planning Analytics 2.0
Excel Version: 1601243020172

Comments and threaded conversations in dashboards

Post by hansTM1 »

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... 8-)
User avatar
gtonkin
MVP
Posts: 1198
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Comments and threaded conversations in dashboards

Post by gtonkin »

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.
User avatar
ykud
MVP
Posts: 148
Joined: Sat Jan 10, 2009 10:52 am
Contact:

Re: Comments and threaded conversations in dashboards

Post by ykud »

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 :)
User avatar
Steve Rowe
Site Admin
Posts: 2415
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Comments and threaded conversations in dashboards

Post by Steve Rowe »

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.
Technical Director
www.infocat.co.uk
hansTM1
Posts: 2
Joined: Wed Mar 11, 2020 2:31 pm
OLAP Product: TM1
Version: IBM Planning Analytics 2.0
Excel Version: 1601243020172

Re: Comments and threaded conversations in dashboards

Post by hansTM1 »

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