Chart not rendering data (Cognos 10 with Netezza)

[jpshetty]

All,

I am using Cognos 10.2 with Netezza as d/b. The issue I have is , the charts not rendering any data. The data is shown in list but the same query in chart says "No data available"... Anyone faced this issue?
When I use cognos sample package, this issue doesn'T arise...

Thanks in advance for any hints, help...

Attached screenshot.
Both list and chart using one query. The data is shown in list but not in chart. I tried different chart types, different data but the results is same.


Cheers
JP

[mitali]

It would be better if you can provide screenshots of your problem.

[jpshetty]

attached screenshot to my post

[bdbits]

I suppose I could be mistaken, but transaction_id does not sound like a measure. You need to use an actual measure for the "Default measure" on the pie chart.

[mitali]

drop any item in axis titles also.