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