COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: rodolf on 13 Nov 2006 04:27:59 AM

Title: [FM] How to avoid sum aggregation on measures?
Post by: rodolf on 13 Nov 2006 04:27:59 AM
Hi,

I do have a measure dimension with Inventory measures in it, with month_key identifier. I do not want any aggregation on it, so in FM I put the measure properties as this:
Regular Aggregate : Unsupported
(but can't change Semi Aggregate from Sum ??? Why???)

When I work with Query Studio I cannot prevent from doing aggregation on my Inventory measures: When I display the mesures in a table month by month, then for every row in the table the measure displayed is the sum of the measures of all the months displayed (so it is always the same aggregated value displayed).

How can I avoid this aggregation?
Many thanks,
Rodolf