Hello
We are using BW 3.5 and we have 3oDS layer I craeted process chain which loads first the staging layer ODS and last after the ODS activation it has step update ODS data ( further Data) I found that first ODS gets updated/activated very quickly but my process chain get stuck in the further update even if the records are like 20 or 24 its taking 2/3 hrs I have setting in my ODS is update further data ( flag is on)
when I cancelled the job and manually loaded it loaded very fast . I checked in SM37 BI_process oDS is always active
what could be the reason for this delay for laoding to next layer of ODS? I tried using load info package (proecss type) but still not working>
Does anyone know what could be the reason here?
Thx
PM