Skip to Content
0
Former Member
Mar 16, 2007 at 08:28 PM

loaded flat file shows double records

15 Views

Hi All,

I have one flat file ...loaded in cube from client workstation.

now when i execute the report it shows the amount column values double.

for eg. i have,

project group= ICW_BW

fiscper = 2006/002, also the currency type is different too.

now i have 4 records with different dates and different amount for same project group...

project group= ICW_BW

1) amount = 1487506.00

2) amount = 178,501.00

3) amount = 1487506.00

4) amount = 178,501.00

now when i run query i do get 4 entries for icw_bw project group but the amount column shows me 4 entries as follows,

1) amount = 2975012

2) amount= 357002

3) amount = 2975012

4) amount= 357002

which are double amount of the original one...can some one tell why is that happening ?