Trouble loading flat file when we need to skip some fields

10 pts.
Tags:
Data load
Data Transfer Process (DTP)
Persistent Staging Area (PSA)
SAP BI
SAP errors
Hello This is the first time that I have tried to create transformations and a DTP. I have a flat file that has three text fields in the file that I do not want to import. When I try to load to the PSA I get the following message; " "Error 'The argument 'PO QTY' cannot be interpreted as a number' on assignment field /BIC/ZQUANTITY record 1 value PO QTY" Message no. RSDS013. I have double checked the DataSource, flat file and DTP layouts. I know that this means that it is trying to read the first text field into the quantity field. How do I preview this? Have I missed a step in the process? Any help at all is greatly appreciated. Renee
ASKED: May 2, 2008  4:34 PM
UPDATED: May 30, 2012  9:36 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello Renee,

Generally PSA is used to load the source system data as it is, with the same structure and meta data. We filter things out or use transformations when we load the PSA data into DSOs or InfoCubes.
The source systems have a limited downtime, they cannot be kept out of service for long. So, the data to be loaded is copied as it is to the PSA.
If you do not need the 3 fields in the DataTarget, I suggest you skip them while loading data to the target (InfoProvider) i.e when you create the mappings.

As far as filtering at PSA level is concerned, I will try that out. Currently, I dont have access to any BI system. I will let you know, once I have tried. Even I am new to BI.

Bye,

Viraj

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jawwad786
    Error 'The argument 'G' cannot be interpreted as a number' on assignment field /BIC/ZBL_QTY record 1 value G Message no. RSDS013 Hi there, i have 6 characteristics with 3 key figures and i believe that i have done everything right but still when i try to load my flat file to datasource, i have the above mentioned error. I created another Infocube contianing the same characteristics and key figures and i did not have any problem in loading my flatfile Can anyone please help solving this problem. JAWWAD
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following