what is exception aggregation

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How dashboard is created in sap bw?

519


how would you do the unloading non-cumulative cubes.

500


Explain customization?

523


How would you do the optimizing the dimensions

485


what is the ticketing tool for wipro and ticketing tool depends on company or client?

6187






What are the restrictions DB connect?

1565


Explain dash board?

515


What is an infocube? What are its different types?

490


What is transfer routines.

516


What are the sap enhancements to enhance fir data?

510


what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?

1130


please tell me the most frequently asked interview questions about sap BW with answers

4537


How do you enter data in real-time infocubes?

488


Where to check the log for warning messages appearing in activation of transfer rules?

521


How do start routine and return table synchronize with each other?

455