TM1 Forum

I have a challange with comments. I'd like to display multiple comments over time for the same cube intersection. By nature comments are overwritten in TM1.

How can I achieve this?

I'm thinking about two comment elements where I can move current comment to historic comments with a TI-process. The historic comment should include information about user and timestamp and comment itself. Comments should be accumulated over time in the historic comment field. I'd like users to be able to run the process individually.

Is this possible or is there a better way?

You can acheive this by use of a TI, that reads the comment currently in the cell, appends a new comment and then writes the new value back to the cell.

cgaunt wrote:You can acheive this by use of a TI, that reads the comment currently in the cell, appends a new comment and then writes the new value back to the cell.

If you have separate cubes for the data and associated commentary then you could look at including a separate continuous date dimension (e.g. Comment_Date) in that cube so that you can track different commentary over time without needing TI. If you have a single cube with current comment, historical comment measures sitting next to the value measure then cgaunt's method seems pretty sound.