Skip to Content
0
Former Member
Dec 02, 2008 at 06:20 AM

Double records getting infoset level.

36 Views

Hi,

We are facing double values coming in report.We have 1 multiproviders and under multiprovider we are having 4 infosets like quarter1 ,q2,q3,q4 infosets.under each infoset we are having ods and master data infoobjects.

Q1,q2,Q3 infosets we are getting correct data at ods level ,infoset level,multiprovider level and report level.

But in Quarter4 level infoset we are getting double values for ex if it having 1 saleorder ,opn amount,net amount,order entry amt in ods level but in infoset level exactly 2 records we are getting and multiprovider also we are getting 2 records and in report level the values becoming double.And all infosets are joined by left outer join.for example opn qty is 100 in ods level

we are getting infoset level two hunder mean 2 same records and report level it is having opn qty 200.

We are not able to find why it is coming.Please can anyone help why double values are coming?

Sridhar