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

[Former Member]

HI Sreeni,

Thanks for the reply.

I want to avoid that process of uploading. I mean, I need to validate my flat file even before uploading the data file.

Regards,

Chandra

[Former Member]

HI sanjeev,

I actually asked for a validation even before the data file is uploaded to execute the transformation file..

Hi Varaprasad,

So, in that case, there are no standard ways of doing that. Then we have to conisder it through coding as you speified. Thanks for the Reply.

Regards,

Chandra

[Former Member]

Hi,

I am bit confused. If you purpose is just validating the data in the flat file with the transformation file before actually uploading, then it is very much possible.

You have the transformation and the required conversion file would convert the external value 'Salary' into your internal dimension ID.

All you have to do it open the transformation file and go to the eData menu and select the option validate and process transformation which would open the dialog box to select the required data file to be validated. The only issue you should have uploaded the file into Data Files. This does not mean you have imported the data into the application.

Thanks,

Sreeni

[Former Member]

Hi,

Unfortunately, I do not think it is possible to pick the file available at a location other than BPC file service. It has to be there to validate before loading.

You can consider with your basis or XI team if there is an option to push this file automatically to BPC file service. It would be a worthwhile only when you have a single large data file. If each user has his or her own budget file, it would be better to upload them.

Thanks,

Sreeni

[former_member190501]

Hi,

Validating a file with out uploading into a server ? I dont think its possible.

What you can do is write a validation program in ABAP to check given transaction data against master data before uploading file into server. But for this user should have an access rights to run this program from back end(ABAP server).

Thanks,

Raju