1.What is exception Aggregation? give Example?
2.what Cell formating? and Advantages?
- 1 Answers
- 12830 Views
- IBM, Mind Tree, I also Faced
- E-Mail Answers
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
What is the difference between sap bw 3.0b and sap bw 3.1c, 3.5?
What are the versions in objects?
What internally happens when bw objects like info object, info cube or ods are created and activated?
what is the data model and how it is use ?
How would you measure the size of a infocube?
How do you enter data in real-time infocubes?
What are the hierarchy relevant parameters?
How will you schedule the job in background?
What is proposed from statistics for aggregates?
I am looking for SAP BI banking reports and business content for banking. Please help
Are there any limitations for bex analyzer?
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
What are the settings for Transport?
how to display the date formats for example i hava a year like 2010 to 2011 bu i want to display in report like 2010-11 can u please explain this
What are the differences between v1, v2, v3 jobs in extraction.
