COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: philelmousse on 24 Jan 2011 05:13:43 AM

Title: Group by clause in a query subject
Post by: philelmousse on 24 Jan 2011 05:13:43 AM
Hi,

I have a query subject who returns that fields :

name
toto
toto
Category
general
general
Month
1
1
Amount
1000
2500

I would like to make a group by to have the sum of the amount for each month. But i dont know where create a group by clause in framework mananger
Title: Re: Group by clause in a query subject
Post by: MFGF on 24 Jan 2011 05:21:33 AM
Hi,

Provided you have modelled your data correctly in FM, this grouping should happen automatically when retrieving data in a report.

How are you generating these results - using the Test facility in FM, or from within a report built in a studio?

What usages are defined on the four query items in FM?

What determinants are defined on the query subject in FM?

Regards,

MF.
Title: Re: Group by clause in a query subject
Post by: philelmousse on 26 Jan 2011 04:16:17 AM
Hi, I have an issue in report studio with a chart who returns nothing so i presume this is an issue in framework manager.

My model is simple, I have a "Database layer" with a stored procedure wich returns me the fields for the reports. I also have a table and I created a join between that 2 queries subject.

I have also a "logical layer" to make the calculation for additionnal columns. I really dont understand why my chart is empty