Enhancement of datasource 0CO_OM_CCA_9

[Former Member]

Hi all,

we have added two new fields to datasource 0CO_OM_CCA_9 (TA CMOD, append to extraktstructure, ...). All works fine in the development systems, sourcesystem R/3 and targetsystem BI.

Now we have to transport these changes to the production system.

The datasource is used in delta-update mode.

What steps do we have to do prior to import these changes in the production system?

First of all we have to clear the delta-queue in R/3, that is loading delta-update to BI-system.

So far so good.

Is there a job running putting data to this delta-queue?

What do we have to do to ensure that no new data is written to the delta-queue before the changes are inported and activated?

Thanks for your help in advance.

Regards,

Achim

[former_member181964]

Hi,

I think your datasource is already in production, and you want to data only from today onwards for enhanced fields, i.e. historical data is not required for enhanced fields..

1.Fix ECC down time for 20 to 30 munities

2. Keep all objects on Qty system in ECC and BW.

3.Run Delta laods in BW for 2 to 3 times.So with this step you can clear SMQ1 and RSA7. Check the entries in RSA7, if it is ZERO then it is fine.

4. Move DS from ECC Qty to ECC PROD .

5. Replicate in BW.

6. Move all BW objects from BW Qty to BW Prod.

7. Delete Init load in InfoPackage level (Not in ODS/CUbe).

8.Load Init without DataTransfer.

9.Then Run Delta.

10. Next day on wards deltas will come as usual.

If you need Historical data also.

1.Delete data in Cube.

2.Fix Down Time and load Init then Delta.

Thanks

Reddy

[lee-yen_tye]

Hi Achim,

May I suggest some additional small tweaking steps and substeps:

1. Flag BWP side downtime for the associated data targets at approx at least 3hrs since the Safety time interval from table BWOM2_SAFETY timestamp table settings for deltas of this D/S is defaulted to 2hrs in BWP, the transports importation and replication steps and the init delta duration may take abit longer than expected.

1a. If necessary, review and pause scheduling of process chains associated with your M/data and data targets.

Continue as previously mentioned etc.

4. Move DS from ECC Qty to ECC PROD .

4a. Confirm transactional D/S transport has been imported OK

4b. Confirm CMOD and enhancement programmes (e.g. FMs) transports associated with the transactional D/S has been imported OK from ECC Qty to ECC PROD. If necessary, review tpcodes and rectify transports.

5. Replicate D/S in BWP.

5a. (optional) confirm CMOD OK via RSA3 on ECC6 PRD side.

6. Move all BW objects from BW Qty to BW Prod.

6a. Confirm all BW objects transports imported OK etc.

Continue as previously mentioned etc.

Good Luck.

Hope this helps.

Thanks and Regards,

Lee

[Former Member]

Hi Reddy,

thank you for your answer.

If have one more querstion:

What could happen to the delta queue if i don't run ECC in exclusive mode during importing the changes to the datasource in ECC?

In any case i have to run a new Delta init.

thanks in advance

regards

Achim

[former_member181964]

Hi,

What could happen to the delta queue if i don't run ECC in exclusive mode during importing the changes to the datasource in ECC?

First clear all Q's i.e. SMQ1 and RSA7, so that is the reason I told run Delta loads in BW for 2 to 3 time, then it will cleat teh Q's in ECC.

Then structure of datasource is chaging , so you will get errors, if you have data in Q's. If some old data is there in Q's and you transported new DS, so it will compare with New Strcuture then it will give error.

Thanks

reddy