Text in Crosstab Fact cells

[santoo66]

Hi
I want to display text data in fact cells of a crosstab
Say i want product type and product name as rows and coloumns of crosstab and the intersection i.e., measure zone should contain Product line information....
Can any one help me out...
Thanks in advance

 

[blom0344]

Cognos does not allow non-aggregates as measures in a crosstab. It is however possible to use a report expression to translate numerical values to strings

Ties Blom

 

[santoo66]

So no other approach

 

[santoo66]

we can display Pass or Fail in crosstab measure by using 'Detail Contents' option in properties window.Here we have the measure like marks>some value.
But in case of my situation i don't have the measure.I can use Product line code but it is a identifier but a number datatype.
Can any one help
Thanks

 

[blom0344]

Write report expression that translates the ID's to strings, like:

CASE
WHEN [item] = 0 THEN '-'
WHEN [item] = 1 THEN 'SO'
WHEN [item] = 2 THEN 'SV'
WHEN [item] = 3 THEN 'SB'
WHEN [item] = 4 THEN 'EB'
WHEN [item] = 5 THEN 'EP'
ELSE '' END

and use this at crosstab fact cells level as :

Source type: Report Expression
Report Expression: << see above >>

Ties Blom