Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Loading Excel File Data Decimal is not being fetched...

Dear All,

I have working on SAP BW 7.3 and following is the format of data in "Excel"

and following is the screen shot of data in DataSource during Read Preview Data.

1. In Excel "Column: A" format is Text and its not being fetching correctly into DataSource Preview data correctly as its missing dot(.) and its after number, why?

2. In Excel "Column: D" format is Number with 2 decimal places but its not being fetching correctly into DataSource Preview data correctly as its missing decimal and its values, why?

3. Do I need to change the column format into Excel or at DataSource level in Proposal tab?

4. What should I do to fetch the record in correct manner?

Many thanks!!!

Tariq Ashraf

Former Member
Not what you were looking for? View more on this topic or Ask a question