Skip to Content

Change the DS and Planning Object in a workbook

Sep 14, 2017 at 08:11 PM


avatar image


I'm working on Business Objects Analysis for MS excel.

Like in BW, where we can copy the Queries on an Infoprovider using RSZC tcode, do we have a provision in Analysis for MS excel where I can copy the Workbook from One DS to another?

For ex: I have a Workbook WB1 with DS DS_1 and Plannning Sequence PS_1 . I want to create a work WB WB2 with DS DS_2 and Planning sequence PS_2. Here the DS_2 , PS_2 is a copy of DS_1 and PS_1.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Sep 14, 2017 at 09:51 PM

You can change the data source by going to the navigation panel, Components tab, and select the "Change" icon next to the Data Source Name - see below:

Good luck; my example is from a 2.5 Analysis Office

chg.jpg (75.9 kB)
10 |10000 characters needed characters left characters exceeded