Hi all,
Quite new to Cognos.
I am trying to model a FM measure that aggregates differently depending on the level.
For simplicity let's say I have a table with a key named TestID, a number called M and 3 other attributes, say year, country and Company.
I want my measure to aggregate as a SUM at each level except Company - in which case I want a Max.
If an end user creates a report containing M, year and country, the M will be calculated as the maximum M value for each company within the year/country.
If you remove Country from the report, the values will roll up by sum(), i.e it will be the sum(max(M by country)) for each country.
However if my report include the Country column, I want to show the detail M values rather than the Max per country.
Is this even possible in Cognos?
Much appreciated
DMR measures support semi-additive aka semi-aggregate functionality.
My work has been with segregated dimensions and measures, not with a table with both dimension and measures together so I have no data on whether it might be doable.