If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[FM] How to avoid sum aggregation on measures?

Started by rodolf, 13 Nov 2006 04:27:59 AM

Previous topic - Next topic

rodolf

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