What should i do to provide the opportunity of my users to create comments and attachments for any cell in TM1 Contributor's cube view, as in EP?
I understand, that it is not base functionality of this product.
Cell comments in TM1 Contributor
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Cell comments in TM1 Contributor
Hi
I haven't used Contributor much, but I think your solution is back in TM1.
For comments alone, I generally create my cubes so the final measures dimension has two elements
Value (Numeric Element)
Comment (String Element)
Then for any cell in the cube, the user can see the number in the Value element, and enter a comment in to the Comment element.
Allowing users to insert attachments is somewhat harder. Potentially you could store a link to the attachment in another String cell.
However, in most cases users don't want to write a Word Document about a single cell.
Regards
Paul Simon
I haven't used Contributor much, but I think your solution is back in TM1.
For comments alone, I generally create my cubes so the final measures dimension has two elements
Value (Numeric Element)
Comment (String Element)
Then for any cell in the cube, the user can see the number in the Value element, and enter a comment in to the Comment element.
Allowing users to insert attachments is somewhat harder. Potentially you could store a link to the attachment in another String cell.
However, in most cases users don't want to write a Word Document about a single cell.
Regards
Paul Simon
-
- Posts: 4
- Joined: Thu Jun 09, 2011 2:30 pm
- OLAP Product: TM1
- Version: 9.5.0
- Excel Version: 14.0.5128.5000
Re: Cell comments in TM1 Contributor
Hi everyone!
I've got the same situation as Asvlad: I have to provide the end user an opportunity to add comments to a cell.
paulsimon, sorry, but your suggestion seems to me half-hearted
.
This function exists in Cognos Planning & Excel and I need exactly the same tool here.
Hope, someone here may give the answer....
I've got the same situation as Asvlad: I have to provide the end user an opportunity to add comments to a cell.
paulsimon, sorry, but your suggestion seems to me half-hearted

This function exists in Cognos Planning & Excel and I need exactly the same tool here.
Hope, someone here may give the answer....
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Cell comments in TM1 Contributor
It may be half-hearted but that is how you store comments in a TM1 cube. You have to define an element in the last dimension as "S" type (for string) and then that intersection in the cube can accept strings. Best practice is that last dimension in the "Measures" dimension just as Paul stated but it doesn't have to be. You can either store comments in the same cube as the data or you can have a separate cube just for the comments and write your reports to pull from both cubes. Your choice. Sorry, TM1 is not Cognos EP. They're moving a lot of the functionality that used to exist in EP into TM1 but they are doing it in stages. In the meantime you'll just have to deal with it the best you can.Ginger wrote:I've got the same situation as Asvlad: I have to provide the end user an opportunity to add comments to a cell.
paulsimon, sorry, but your suggestion seems to me half-hearted.