COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gpreddy1986 on 19 Aug 2010 04:48:44 AM

Title: Diff B/w total and Summarize
Post by: gpreddy1986 on 19 Aug 2010 04:48:44 AM
can u pls explain diff between total and summarize.. in which case we use total and in which we use summarize function........ thanks
Title: Re: Diff B/w total and Summarize
Post by: MFGF on 26 Aug 2010 07:51:51 AM
Hi,

Total() will do exactly as you imagine - total the measure values, regardless of the default aggregation defined for the measure in Framework Manager.

Summarize() will summarize the measure using the default aggregation defined in Framework Manager - eg. if the modeller has defined this as average, then the measure will be averaged by the Summarize() summary.

MF.