TM1 Forum

I have numeric data which are consolidated in the cube. And i want to display a '-' instead of the number for the consolation. I need to se the base (:N) elements data but the consolidation should just display a character (-).

Can i please know if there is any solution for this using rules.

Thanks,
Sravan

'-' is a String not a number and you can only display a Number in a cell which is number format.

You can write a Rule to display a number for specific Consolidation. You can say
This rule will write 0 for all the consolidations in your cube. Note that you will have to use SKIPCHECK and FEEDERS in your rules.

Hope this helps.

tosravan wrote:I have numeric data which are consolidated in the cube. And i want to display a '-' instead of the number for the consolation. I need to se the base (:N) elements data but the consolidation should just display a character (-).

Can i please know if there is any solution for this using rules.

In addition to the preceding suggestions, if you're only looking at data within the cube viewer you can apply a Custom format to the consolidated element via the dimension's Element Attributes editor. However this will have no effect when you slice it. Also if the consolidation is intending to
merely group elements rather than consolidate them, consider weighting each member with a weight of zero (meaning that the consolidation will also return 0) so that there's no confusion on the part of users. It won't get you the dash that you're after, but it'll prevent a bogus number from being calculated.

rkaif wrote:Note that you will have to use SKIPCHECK and FEEDERS in your rules.

When all you want to see on Consolidations is 0 calculated via rule, you'll only need SKIPCHECK.

Thank you all for your replies.

I did make the field display a 0 before posting here. I was only wondering if there is any way we could display '-'. After reading your replies, i was able to communicate to my business users that '-' can not be displayed and 0 can be displayed.

They were OK with the 0.

Thank you.

Hi

Maybe you missed Alan's suggestion.

Right click on your dimension and select Edit Element Attributes. Click in the Format column next to the Measure that you want to format. Click on Format. Select a Custom Format enter the following:

#,##0;-#,##0;\-

The different formats are separated by ';'

The first is for positive values, the second for negatives, and the last is for zero values. The character \ is an escape character which means that the next is to be treated as a literal, so '-' is treated as a literal '-' rather than as a minus sign for a number format.

You can also use this technique to put out messages, eg a kind of conditional formatting so negatives can put out 'Bad' and positives 'Good', etc.

Regards


Paul Simon

Depending on your delivery mechanism it is relatively easy with number formatting to make 0 appear as "-"