restructuration and reinitialization

[Former Member]

Hi All,

I'm new with SAP BW and I've got the following problem.

I need to delete the content of a cube and to reinitialize it.

I did:

1. deschedulation of the 2LIS on R3;

2. deletion of the init on the cube;

3. deletion of the data on the cube;

4. deletion of the setup table related to this application on R3;

5. restructuration of the setup table related to this application on R3;

6. init without data on the cube;

7. reschedulation of the 2LIS on R3;

8. restructuration of the created/modified "number of material document" between (2) and (6);

9. full repair on the cube with all the "number of material document".

Now the problem is:

I found that with the first delta there are "number of material document" created/modified between the last 2LIS before (1) and the first 2LIS after (7).

So it seems that the 2LIS never stopped to record created/modified "number of material document".

So I ask You all:

1. Didn't the 2LIS have to sinchronize itself with the last init on the cube?

2. How can I REALLY stop it?

Thanks in advance (and sorry for my english),

ZioCino.

[Former Member · Accepted solution]

hi,

i have sent

cheers,

swapna.G

[Former Member · Accepted solution]

Ok, it is very useful and you helped me much...

Thank you...

Only one question:

- in step 1.2 it refers to steps 2.5.1 and 2.5.3: what are that steps?

Thanks,

ZioCino.

[Former Member]

Hi ,

step 1 and 9 are about descheduling and rescheduling of v3 jobs

pls provide your email ID i will send the doc on how to deschedule and reschedule of v3 jobs with screenshots

cheers,

Swapna.G

[Former Member]

Hi ,

the procedure is as below:

1.deshedule the v3 jobs

go to LBWE ,select the application (02,03 etc..)click on job control,click on job overview and delete the released job for the relavant application

2.delete the contents(fact and dim table)

3.delete init flag(cross check no entry in RSA7)

4.delete the setup tables(lBwg)

5.cross check in se16 whether the contents have been deleted or not(name of the setup table is (extract structure namesetup)

6.refill the setup tables with selections

7.run repair full possible only if the target is ODS

8.if not run init with data

9.reschedule v3 jobs

10.run delta load

cheers,

Swapna.G

[Former Member]

Ok, got it...

Only there are two steps that I don't fully understand; they are step 1 and step 9...

I edited the R3 job status to Planned, I didn't delete it...

If I delete it how can I recreate it then for reschedulation? (remember that I'm new to SAP BW )...

Thanks in advance,

ZioCino.