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...
Comments and threaded conversations in dashboards
- gtonkin
- MVP
- Posts: 1199
- 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
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.
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.
Re: Comments and threaded conversations in dashboards
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
- Steve Rowe
- Site Admin
- Posts: 2416
- 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
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.
This has been previously raised and rejected in the RFE portal.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- 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
Ok thanks all for your replies, i'll further investigate on the websheets.