Hi Experts
have to build a process chain on master data which will have historical data coming and if it is -5 days in the month (all 12 months in a year), all the data goes into a historical DSO and if is after 25 days for eg: it remains current. And after historical data gets loaded it has to load into another historical cube in another BI system and then delete the data in the current DSO and wait for the next month historical data to come.
This is the scenario. Experts can you please help how to proceed with this?
Swetha