what is exception aggregation
Answers were Sorted based on User's Feedback
Answer / nimma
The Exception aggregation is used in special scenarios
where we do not want to show the result of key figure as
simply the total of all the values. For example:
Is we are looking at a report which shows the Number of
employees by year for the past 10 years the total field for
the Number of employees shows the total of all the figures
for the past 10 years which is wrong but it should show the
last value i.e the recent years figures becoz the number of
employees is not something to add up.
Here we use the exception aggregation to let the BEx know
how to show/summarise the values, here in this case we use
Last Value...
Some more examples of exception aggregation are Average,
First Value etc...
Is This Answer Correct ? | 108 Yes | 4 No |
Answer / sudhakar
Exception aggregation can be used to derive additional information out of a limited number of Key Figures provided in the InfoCube that is to be analyzed.
Thereby, you can create Calculated Key Figures by using a formula that uses exception aggregation itself (this is a nested exception aggregation).
Example: Exception Aggregation as "Total" is used to aggregate the result of a key figure with respect to the Reference Characteristic.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / damodar reddy
Exception Aggregation is which specifies how key figure is
compressed using time characterstics
Is This Answer Correct ? | 2 Yes | 33 No |
Answer / surya
Exception in Reporting is to indicate any deviation from a
threshold value. Say you build a Query for Sales Analysis
for various salesorganisations for a top level manager in
sales, You indicate some threshold values in Netsales Amount
to indicate if it is exceptionally low or high , with
different colors in the report, so that it could be
immediately taken care . The same exception can be reported
with the help of reporting agent , by capturing the
exception and sending the same through Emails to managers.
Is This Answer Correct ? | 5 Yes | 108 No |
Compare info cubes with operational data store?
How do you send XML data to BW?
What is the propose from statistics for aggregates?
What is a link node?
4 Answers i Tech, TekLink, Wipro,
Define a data source?
What are the naming conventions used for aggregates created from query?
what are the different components in dso architecture?
What is a source system?
I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
What are value sets?
What exactly do you know about business warehouse statistics?
What is the program to maintain change run?