Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jpshetty on 18 Nov 2014 05:05:05 AM

Title: Chart not rendering data (Cognos 10 with Netezza)
Post by: jpshetty on 18 Nov 2014 05:05:05 AM
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
Title: Re: Chart not rendering data (Cognos 10 with Netezza)
Post by: mitali on 18 Nov 2014 05:43:10 AM
It would be better if you can provide screenshots of your problem.
Title: Re: Chart not rendering data (Cognos 10 with Netezza)
Post by: jpshetty on 18 Nov 2014 06:15:09 AM
attached screenshot to my post
Title: Re: Chart not rendering data (Cognos 10 with Netezza)
Post by: bdbits on 18 Nov 2014 09:40:26 AM
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.
Title: Re: Chart not rendering data (Cognos 10 with Netezza)
Post by: mitali on 18 Nov 2014 10:44:10 PM
drop any item in axis titles also.
Text only | Text with Images