Skip to Content
0
Former Member
Nov 13, 2012 at 06:49 AM

Data Services - Data Flows Replication

958 Views

I'm building 60 validation rules in SAP BODS. Each validation rule is in the form of the following data flow :

so in total I have 60 data flows.

My problem is that I have to do these 60 validation rules for 10 affiliates/companies using the same source tables but I want to store the failed records in separate tables for each company. The way I filter based on company is by changing a value for one field in the "where" clause in the Query transform. (e.g. Where company = 'xxxx') where 'xxxx' is different for each company. ==> total = 600 data flows and each one is a job ==> 600 jobs.

I want to create 60 jobs under a project and then copy/paste 10 times, but this feature isn't available in BODS. What is the easiest way to replicate the 60 jobs 10 times ?