Skip to Content
0
Former Member
Dec 12, 2011 at 03:35 PM

Data Mismatch - Text File vs DSO data

14 Views

Hi All,

I got a requirement to load data from a Text file into BI with fixed length. There is a quantity field with lenght 13 and data type as QUAN.

When I tried to map this quantity field with Quantity Key figure then it throwed error saying lenght mismatch. So I created a Characteristic Info Object with data type as Number and given length as 13.

The problem is, now I am not getting correct values for Quantity field in BI.

For eg. when Quantity is 900.00 in text file, I am getting 90000 in BW. Could anyone let me know how to solve to this issue?

Thanks in advance.

Mahi.S