Question:
Hi,
Im struggling a little bit to understand the principle of exception aggregation.
I have a keyfigure Headcount that has exception aggregation "last" for characteristic calmonth. Can anyone be so kind to explain me what this exactly means ? If I run a query for a full year, will this keyfigure be shown as the sum of the last month only ? (december) Or do I see this wrong.
Second related question :
Does this setting mean on cube level my data for this keyfigure will already be aggregated or is this on query level ?
Thanks,
Vinnie Johnson
Answer:
The answer to your first question is yes. For the second question I think it does the aggregation at the query level.
regards
Poonam
Answer:
Yea... it aggregates at query level when you select 'last value'...