COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: psrpsrpsr on 02 Dec 2016 02:56:49 PM

Title: How come this chart is not rendering data that is returned in the query?
Post by: psrpsrpsr on 02 Dec 2016 02:56:49 PM
Hi folks, I am validating a report in Report Studio 10.2.2 that was built by someone else.

There is a line chart that is not rendering large swaths of data, even though it can plainly be seen in the query output.

I have played around with the aggregation of the Default Measure, per some other forum posts, to no avail.

I would appreciate if anyone has insight into this. Thank you!

(http://i1305.photobucket.com/albums/s557/PSRNHME/Chart%20not%20rendering%20data%20returned%20in%20query_zpsl4bovupv.jpg) (http://s1305.photobucket.com/user/PSRNHME/media/Chart%20not%20rendering%20data%20returned%20in%20query_zpsl4bovupv.jpg.html)
Title: Re: How come this chart is not rendering data that is returned in the query?
Post by: psrpsrpsr on 02 Dec 2016 02:57:58 PM
Whoops, looks like the image did not embed in the post. It is attached, and here is another try at embedding:
(http://<a%20href="http://s1305.photobucket.com/user/PSRNHME/media/Chart%20not%20rendering%20data%20returned%20in%20query_zpsl4bovupv.jpg.html"%20target="_blank"><img%20src="http://i1305.photobucket.com/albums/s557/PSRNHME/Chart%20not%20rendering%20data%20returned%20in%20query_zpsl4bovupv.jpg"%20border="0"%20alt="%20photo%20Chart%20not%20rendering%20data%20returned%20in%20query_zpsl4bovupv.jpg"/></a>)
Title: Re: How come this chart is not rendering data that is returned in the query?
Post by: bdbits on 02 Dec 2016 04:00:30 PM
Are you certain the chart and list are the same query?

Have you tried dropping and recreating the chart? It looks pretty straightforward to recreate.

Title: Re: How come this chart is not rendering data that is returned in the query?
Post by: sdf on 04 Dec 2016 07:28:35 PM
there's discrepancy in the highlighted values, they don't match.
Title: Re: How come this chart is not rendering data that is returned in the query?
Post by: psrpsrpsr on 05 Dec 2016 08:29:10 AM
Bdbits, yes I am sure the chart and list are in the same query. I have tried re-creating the chart in both line and bar charts. The data is still not rendering on the chart.

Sdf, you are correct – in my haste, I highlighted the wrong rows. I will re-upload the image to show that the query is returning data for those Series.