Creating Charts through Custom SQL Query

[Captain]

I am using a custom SQL Query; all data items show up fine and works perfectly within a list. However, there is no data when I drag the data items from that query into a chart series/measure. It's apparent charts do not behave like like a list when it comes to custom SQL query. Does anyone have any advice?

Thank you.

[bdbits]

I have almost never found a need for custom SQL queries, but the data items from such a query should work fine. Perhaps you are not assigning proper data items to the correct parts of the graph. It might be useful if you could attach a report spec demonstrating your issue.

[Captain]

I have found the solution: properly assigning the aggregation function on each individual data item measure seems to have solved the problem.

PS: You will need custom SQL queries when you want to join data across multiple DBs, for example.

[MFGF]

PS: You will need custom SQL queries when you want to join data across multiple DBs, for example.

Hi,

What led you to that assumption? Describing data from multiple databases (including how it links together) is all part of the standard functionality in Framework Manager. Cognos 10 is designed to handle this easily in the metadata layer. Why do you believe it requires custom SQL within a report?

MF.

[MPritchard55]

Captain -

I am experiencing this problem.  Can you remember what you had to assign the aggregation function to?  Mine are defaulted to 'Automatic'.  I've tried changing to none, total, etc and my graph still won't render.