Replacing system in AO for few sheets

[former_member327592]

Hi,

We have AO work books which are formatted with layout. They have multiple sheets comes from two different Bex reports sourced from single BW system.

We have recently migrated our BW system to new BW4HANA system in which only one Bex query is migrated to BW4HANA.

I would like to replace the work book ie One query from old system source(BICs connection X) where as second query from new BW4HANA system(BICS connections Y) keeping the same format.

I have noticed there is option to replace system but this is trying to replace the whole Work book.

Is there any way to select only the selected sheet(Data source)need to be replace with new connection?

There is option to change Data source but using this option, i am loosing the format because the connection name is changed.

Any suggestion please?

Thanks

replace.png

[VijayetaSharma]

Hello Manoj,

Did you find provided solution helpful?

Thanka,

Vijayeta

[VijayetaSharma · Accepted solution]

Hello Manoj,

You can do this by splitting the workbook into two and the merging them again, before you use replace system option. Though I don't recommend having single workbook point to two system system. As once you have achieved the workbook setup, when you try to connect again (say refresh BW4 sheet) Analysis will try to validate both sheet at one and give error.

Best option for you would be to split them and keep them separate.

Thanks,

Vijayeta

[KonradZaleski]

1. System replacement functionality works for entire workbook, so you cannot selectively replace the system for specific sheets.
2. This functionality works only if the source and target data sources have exactly the same technical names. On influence.sap.com there was initiative raised to add this functionality to AFO, but recently I got an update that SAP does not plan to implement it: