Skip to Content
0
Former Member
Jan 23, 2012 at 07:04 AM

Automate data load

50 Views

Hi,

I have 9 loads to be done from BI to BPC on daily basis in the below manner.

1. Delete data from BPC cube with selection current month and particular version

2. 9 loads from BI - BPC with selection current month

THis seems like a routine work. Any suggestions to automate this process with least user intervention? I see some of the below challenges while trying to automate the process.

in step 1 - automation has to take care of changing the mode of cube before and after deletion

in step 2 - Validation of data needs to be carried out before loading data from BI to BPC. There might be master data variation in BI and BPC.

Regards,

Swetha