Skip to Content

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

Flat file load to BI 7 cube


Does the Position of fields in the Transformation in BI 7 have to be the same as the sequence of fields in the Datasource?

I'm trying to load a flat file but my first field in the DS and flat file is a 4 char field. In the PSA, it only shows 2 characters and truncates the rest.

I checked the transformation and the 1st position is of a field that is a CHAR 2.

How can I change the position of the field in the transformation?

Thank you

Former Member
Former Member replied

No need to change anything in the transformation. Just make sure that the order of fields in the flat file datasource matches the file and the data types and lengths defined in the datasource are correct.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question