I am facing the problem in ODS infoset report.
Consider the two ODS (ie ODS1,ODS2)
<b>ODS A</b>
<b>A B Sal1(KF1)</b>
1 10 10,000
2 10 20,000
Here A is the Keyfield of ODS A (all A,B, Sal1 are infoobjects).
<b>ODS B</b>
<b>B Sal2(KF2)</b>
10 4000
Here B is the Keyfield of ODS B.
I have joined two ODS using Infoset.
Joining condition: OSD A(charactersitics B ie value 10) joined with Keyfield of ODS B(ie B value 10)
While exectuing the Report i am getting the following output.
B Sal1 <b>Sal2</b>
10 30,000 8000(wrong data)
Sal2 is summed twice since in ODS A it is having 2 records.
My requirement is i wnat O/P as
<b>B Sal1 Sal2</b>
10 30,000 4000
With regards,
Hari.
+919323839017