Skip to Content
0
Former Member
Nov 09, 2007 at 08:19 PM

Process Chain: Delta to Cube Fail

11 Views

Hi All, I am using a process chain which has the following sequence: Start>>Delete Data in ODS>>Full load to ODS>>Delta to CUBE

Before running the process chain I manually loaded ODS & did a manual init to Cube. Then tried to run process chain, it fail while loading to cube, with a message that "Check: No successful initialization of the delta update took place". I checked before running the process chain, the schedules has the entry for the init request. I guess when the ODS data is deleted the init entry from the schduler get deleted.

The reason I delete ODS is because each day full loads keep getting accumulated & ODS gets fragmented. This was affecting the reporting performance. Now since I have deleted the old full loads out of ODS, reports run faster. But since I delete ODS, I lose the init request for the cube. Is there a work around, to do delete the full loads out of ODS & still do delta to the cubes?

We are on BI 7.0 sp 13. kindly help

thanks

PK