COGNOiSe.com - The IBM Cognos Community

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

Quote from: Rjmccready on 22 Oct 2015 05:57:30 AM
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

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