Skip to Content
0
Former Member
Nov 09, 2005 at 09:12 AM

Problem in Generating the Infoset report(two ODS joining)

17 Views

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