Display string measure from TM1 in crosstab report in cognos 10.2.2

[Rjmccready]

Hello

My report has an hours measure (numeric) and a string measure called comments, my report displays the numeric value fine but the comments measure shows 2 dashes -- and no value.
The datasource is a TM1 cube which displays string fine in the tm1 architect but not in report.

I have tried to change the data format of the cell to text, also create a seprate data item convert to string using functions but nothing worked so far.

Any advice on working round this would be appreciated.

Thanks

[Lynn]

Hello

My report has an hours measure (numeric) and a string measure called comments, my report displays the numeric value fine but the comments measure shows 2 dashes -- and no value.
The datasource is a TM1 cube which displays string fine in the tm1 architect but not in report.

I have tried to change the data format of the cell to text, also create a seprate data item convert to string using functions but nothing worked so far.

Any advice on working round this would be appreciated.

Thanks

Here are a couple of prior posts on that topic.

http://www.cognoise.com/index.php/topic,16669.msg48891.html#msg48891

http://www.cognoise.com/index.php/topic,19580.msg58225.html#msg58225

[Rjmccready]

Thanks for your help,  we can get away with putting the same information into a list allow us to drop the crosstab .