COPA Realignment in R/3 -do i need to Re-initialize the Delta Process in BI

[Former Member]

Hi frnds,

Im facing an issue related COPA realignment,

1.Once the COPA realignment is done in R/3, Do i need to Re-initialize the Delta Process in BI?

Edited by: MohanDP on May 4, 2011 8:37 AM

[Former Member]

Hi,

Please check the next messgae.

Regards,

Rahul

Edited by: Rahul Adhyapok on May 6, 2011 11:24 AM

[former_member186445]

additionally to above remarks :if you want to have your historical data in line with R/3, you need to do a full reload.

[Former Member]

hi,

Please check in source system in table TKEBWL if the COPA data source has FLAG_DIRTY field set, if yes then you need not reinitialize the delta, otherwise you need to redo the init.

regards,

Arvind.

[Former Member]

Hi,

Realignments are quite common in R/3 and the change the historical data during a realignment run.

to avoid reinitialization you can set the FLAG_DIRTY field in table TKEBWL.

This will make sure that the deltas arent affected and no re-initialization is necessary.

You can set the Dirty flag by writing an abap code.

Regards,

Rahul

[Former Member]

Hi Rahul Adhyapok

As you said to avoid reinitialization you can set the FLAG_DIRTY field in table TKEBWL.This will make sure that the deltas arent affected and no re-initialization is nedded.

But i need historical data too,so how to avoid Re-initialization to get historical data.Can u please help.

Edited by: MohanDP on May 5, 2011 8:44 AM

[Former Member]

Hi Mohan,

When a realignment is run, it is done with specific selections. For eg Sales organization, Division etc.

You can check the selection used to run the COPA realignment.

Then using these selections, you can selectively delete the data from BW side and then do a full repair for those selections only.

Regards,

Rahul

[former_member186445]

But i need historical data too,so how to avoid Re-initialization to get historical data.Can u please help

if you need the changed historical data, you have no choice but to reinit. you can do this at anytime, you don't need any downtime for copa init.

M.

[Former Member]

Hii All

Thanks for ur replies...,

Only solution as you people said.., I re-initialized the Delta Process.