Crosstab measure value as text

[KVBR]

Hi,
I need to display text values in measure area in crosstab. I am using Cognos 8.2, Query Studio.

One method we found is, Conditional text. But here we can't assume the number of values to display.

Here is the Example.
                     Day1       Day2      Day3      Day4          Day5
Prod1             Cname1   Cname2               Cname3
Prod2                                        Cname3
Prod3             Cname2
Prod4                                                                  Cname1


Here Cname's are Customer Names, which have to display in the Measure Area.

Thanks,
KVBR.

[COGNOiSe administrator]

It was attempted by many with no or limited luck. Search the forums for some pointers.

[paulmaric]

Still seems to be impossible with C8.4, but it may be possible if the data is stored as an ASCII representation of the text you want to display, then create a javascript function to convert the ASCII to text.  I haven't done this, but it could be worth a try for someone who needs to.

[david.stachon]

...a little bit ironic, but you could to this in Impromptu.

You're only option in C8 will be to pivot this data (i.e. make rows into columns), and use a list.

Ideally, this transformation should occur in your warehouse as opposed to in FM or in a report.