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

Apart from r/3, which legacy db you used for extraction ?

0 Answers  

---

What is Cell Definition ?

1 Answers   Satyam,

---

Hi friends gm to all , i had done bi with integrating planning. and I have full knowledge on integrating planing, but I don't faced any interview's in ip now, So friends have we any interview questions like Integrating planning, pls send my mail ID.

0 Answers  

---

What are the important formulas available in BW?

2 Answers  

---

In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?

0 Answers  

---

How would you optimize the dimensions?

0 Answers  

---

what is the include program name?

0 Answers  

---

How is multi provider different from info set?

5 Answers   EDS,

---

what is reconcillation? where can u find the option.( cube( f/ e table or ods or aggregates)?

3 Answers   HCL, Satyam, Syntel,

---

What is change run?

1 Answers   TCS,

---

What are the two fact tables?

5 Answers  

---

WHAT IS THE MAIN DIFFERENCE BETWEEN INFOPACKAGE & DTP? WHAT ARE THE REPEATED TABLES WE ARE USE IN REALTIM PROJECTS? WHAT IS THE DELTA UPDATE IN LOCOCKPIT? WHAT ARE THE TABLES IN SD,FISL & MM? How to we modify the processchain running errors? what is the repeated error in realtim projects? tel me the realtime flow & hw to answer the interview level?

4 Answers   TCS,

---