Cell comments in TM1 Contributor

Post Reply
asvlad
Posts: 27
Joined: Wed Mar 17, 2010 2:41 pm
OLAP Product: TM1, Transformer, EP, MSAS
Version: 2.0.6
Excel Version: 2016
Location: Russian Federation

Cell comments in TM1 Contributor

Post by asvlad »

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.
User avatar
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

Post by paulsimon »

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
Ginger
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

Post by Ginger »

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....
tomok
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

Post by tomok »

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 :(.
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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply