Print Page - Aggregate and Rollup aggregate

Title: Aggregate and Rollup aggregate
Post by: cognosmanager on 22 May 2012 01:59:22 AM

Hi All,

I have a report in which some portion of data taken looks like this:

emp id name pay
1234 XYZ 2000
1234 XYZ 0

so two rows are coming up in this report. So in order to have a single row I changed the property of "Pay" for Aggregate: Total, Rollup Aggregate: None.

After doing this one row is coming but the "Pay" column is showing 4000, i.e. is doubling the data.

I have many other emp id with which this function is running fine but not with this.

Please help me out.

Title: Re: Aggregate and Rollup aggregate
Post by: saumil287 on 23 May 2012 03:57:27 AM

Hi,
Change the Pay to aggrgate only
and try roll up property to ggregate .

If not then look properties of these items in framework manager .
Test the data from FM first.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cognosmanager on 22 May 2012 01:59:22 AM