what is exception aggregation

Question Posted / anil kumar

4 Answers
31513 Views
Accenture, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is exception aggregation..

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

what is exception aggregation..

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

what is exception aggregation..

Answer / damodar reddy

Exception Aggregation is which specifies how key figure is
compressed using time characterstics

Is This Answer Correct ?

2 Yes

33 No

what is exception aggregation..

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

Post New Answer

More SAP BW (Business Warehouse) Interview Questions

How do you delete change log?

2 Answers

what is fullform of sap & college, institute of sap course

2 Answers Adani,

What is a control query?

0 Answers

Where do you find which table is currently being populated (BIW1 or BIW2)?