Change the DS and Planning Object in a workbook

[Former Member]

Hi,

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.

[TammyPowlas]

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