Monday, December 28, 2009

Why do you see date/year or customer number or invoice number fields with values like 2016, 2032, 8022?

The reason is aggregate property was set incorrectly by the modeler. The modeler set the aggregate property to ‘Total’.

The aggregation for Attributes should be set as None, unsupported or maybe count.
Summarization should be performed only on Facts and not on attributes.
You as a report developer can set the aggregate property to ‘None’.