COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: numbsyd on 14 Oct 2015 08:29:12 AM

Title: Bubble chart with SQL query
Post by: numbsyd on 14 Oct 2015 08:29:12 AM
Hello mates,
                      I'm using SQL query to fetch summarized values and visualize it in Bubble chart, i've set query subject auto aggregate property to no and query items aggregate properties to calculated. the data from the query is attached here(atleast when run in DB) but report studio doesnt' consider the result set but picks random or unreasonable data.

can anyone help please. thanks in advance.

Regards,
Sid