Skip to Content

Change the DS and Planning Object in a workbook

Sep 14, 2017 at 08:11 PM


avatar image
Former Member


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