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 ?