Name of data item stops a chart showing in Cognos

[ashleh]

Right, I have a really peculiar issue that I cannot seem to figure out why it would be happening. I have a list with a line chart inserted (using a master-detail relationship to another query) and then other columns containing data.



From the first table, you can see 'Academic Services Spend (£000s)~' has no trend line, whereas the rest do. If I view tabular data for the trend line, there is definitely data there.

From the second table (which is exactly the same) I renamed 'Academic Services Spend (£000s)~' to 'A' and the trend line suddenly appears?! This happens to a few other of the indicators as well and if I rename them they seem to work. I thought it might be due to the length of the string but there are ones with 50+ characters which have a trend line showing so this can't be the case. Any ideas why this might be happening? I can provide more information if asked for. Thanks.

[CognosPaul]

What is your database? Is it DB2 or A/S400 by any chance?

[ashleh]

DB2 I believe.

[CognosPaul]

I've had this problem with DB2 before. When Cognos generates the SQL, it tries to use the data item names you've supplied in the SQL itself. DB2 seems to choke on special characters. I've given up trying to understand why, just set the name you want to appear as the label and give a generic name to the data item.