Manually insert a comment above a rule

[gernosh]

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.

Code: Select all

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.

[Wim Gielis]

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.