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.
It was attempted by many with no or limited luck. Search the forums for some pointers.
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.
...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.