@ shown instead of empty cells in IBM Cognos Insight

Technote (troubleshooting)


Problem(Abstract)

An empty cell is displayed as @ in a crosstab in IBM Cognos Insight, instead of no value being shown. IBM TM1 Architect shows all the values correctly.

Cause

An invalid format was set in element attributes for the dimension. In this case a c:"" was set, to exchange all 0 values with an empty space only for this one dimension.

Resolving the problem

Set a format as described in the documentation: http://pic.dhe.ibm.com/infocenter/ctm1/v10r1m0/topic/com.ibm.swg.ba.cognos.tm1_ug.10.1.0.doc/c_tm1displayformats_n70007.html#TM1DisplayFormats_N70007

Example pattern: #,##0.00;(#,##0.00);"";"" .

The first two values in this pattern, represent the positive and negative values. The 3rd and the 4th value represent zero and NULL values. This will format all values with two decimals and zero or NULL values will be displayed as empty string.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Insight

Software version:

10.1, 10.1.1, 10.2

Operating system(s):

Windows

Reference #:

1621304

Modified date:

2013-01-04

Translate my page

Machine Translation

Content navigation