TM1 Forum

Posted: **Thu Mar 21, 2019 12:58 pm**

Hi guys,

In this cube, I have two measures, 'Valor' and 'Comentário' (is comment in Portuguese).

I created one rule to dont supress Comentário column when the measure valor not is equal to zero.

FeedStrings;
SKIPCHECK;
['Comentário'] =S:if(['Valor']<>0,'Comment here',STET);
FEEDERS;
['Valor'] => ['Comentário'];

But I need users to manually insert comments above the rule, where the value is equal to 'Comment here'.

How can I do this?

these images do not represent actual values about my customer.

Posted: **Thu Mar 21, 2019 1:05 pm**

With text elements like 'Comments', please think about the implications. It seems that you have quite a big number of dimensions in the cube. As text values do not add up like numbers would do, it's very important to know in which slice of the data, at what level of detail, comments will be entered and stored. If not, no one is ever going to find back the comments. Therefore, think about a smaller cube with less dimensions and lay out the input in Excel / Web / PAW / PAX such that you have cells pointing to both cubes next to each other as 1 'report'. In the cube viewer it will be 2 different cubes.

TM1 Forum

Manually insert a comment above a rule

Manually insert a comment above a rule

Re: Manually insert a comment above a rule