COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: RubenvdLinden on 27 Aug 2012 10:27:06 AM

Title: New dataitem for rollup aggregations?
Post by: RubenvdLinden on 27 Aug 2012 10:27:06 AM
We recently upgraded to Cognos 10.1.1.

In Cognos 8.4, I could insert a dataitem 'Client' to my report, set the rollup aggregation function to 'Count' and then use the 'Summarize' -> 'Count' button to create rollup footers based on the 'Client' dataitem.

In Cognos 10.1 I can do the same, but then Cognos adds a new separate dataitem called 'Count(Client)' to display in the footers. I really dislike all those extra dataitems just for summaries.

Is there a setting to revert to the Cognos 8.4 behaviour?
Title: Re: New dataitem for rollup aggregations?
Post by: ahmerzaidi on 28 Aug 2012 12:15:40 PM
I'm not sure of a way to revert to the old behavior, but you can unlock the report remove the auto generated data item and place in your own data item.
Title: Re: New dataitem for rollup aggregations?
Post by: RubenvdLinden on 30 Aug 2012 04:43:25 AM
Yes, I found out that could be done as a workaround.
It would be nice if there's a way to revert back to the old behaviour, because it's a lot of work to replace all the autogenerated dataitems.