Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

1.What is exception Aggregation? give Example?

2.what Cell formating? and Advantages?


Answer Posted / keerthi

SAP Infoobject Exception Aggregation: A working example.

Sometimes the key figures that are displayed in a query are
not expected to be summed together in all situations. Take
the Headcount Key Figure below. The data is contained in
the cube by month in order to display the monthly salaries
(Figures are fictional). In the example data there are four
employees, two each in Oil & Gas and Refining with one
employee leaving at the end of July.



You can see from the queried data below that the monthly
figures are correct, two employees per sector. However the
Quarterly and Annual totals are incorrectly summed at six
and twenty four respectively.



The neatest way to deal with this is to use Exception
Aggregation. This is configured in the Infoobject directly.
The screen shot below contains the original key figure and
a second key figure that I've created with the Exception
Aggregation configured. In this case I have selected to use
the average figure for the summation using 0CALMONTH as the
reference characteristic as it's the lowest denominator.



I've added the second key figure to the report in order to
highlight the differences. As you can clearly see the
Headcount Exception key figure has totals of two for the
month, quarter and year totals. The fact that one employee
has decided to leave is also picked up and calculated
accordingly.



Obviously this is not always required, revenues for example
would generally always sum normally, there are however
exceptions, hence the name.

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why ods activation fail? What types of fails are there? What are the steps to handle

1829


what is high cardinality tell me brief

1529


is their any difference between bex 3.5 and bex 7.0?

4029


What is the use of infoarea in sap bw system?

1020


How would you do the archiving cubex.

964


What is bp master data.

973


When is idoc data transfer used?

1057


How does the time dependency works for bw objects ?

949


How do I separate development from the production environment?

895


In real world when do you recommend aggregate?

2423


What is extraction setup?

2168


What is an infocube? What are its different types?

933


What are the proposal options available?

2394


What is data flow in bw/bi?

1048


Describe your experience with bw extractors

984