Validating Master Data from upload File

[Former Member]

Hi Experts,

We have a business process, where the user will be given a template to upload the Budget data.

In the template the user enters the description of the members instead of Dimension memebr ID's. For Ex. The Dimension member ID for Salary Account "100000", and the description is "Salary", the user enters "Salary" in the P_Acct Column which we will converted during the upload through a conversion file.

Once the data is entered, he will have to upload the file(using data upload option), Execute the transformation file to validate the data, and upload the file using the Data Manager.

We just want to know whether we can validate the file even before the File is uploaded to the server. As this will help the user to upload the file once for all. Otherwise, he may have to upload it multiple times, if any records were rejected during the validation step(As he has to make suitable changes to the file and upload it again).

We would be gald to know if there is some way to validate the file before(before the first step). Please let me know if any further information is required on this.

Regards,

Chandra

[Former Member · Accepted solution]

Hi Chandra,

You should have VALIDATE RECORDS = YES in OPTIONS section of the transformation file.

When you have the master data file ready , You can validate it before loading it to BPC.

Navigate to DATA MANAGER--> VALIDATE and PROCESS TRANSFORMATION FILE then you will be asked to data type of the file like master data from flat file / transaction data file and then click on SAVE.

If there are any rejected records you can see them in the rejected list. Hope this information helps.

Regards,

Sanjeev