Change datasource of Analysis for Office workbooks

[Former Member]

Is it possible to change the data source of workbook in Analysis for Office 2.7, without loose the structure of crosstabs?

I have different systems (dev, test and production) and I need to switch a workbook from a system to another.

I tried to unzip xlsx file to change xlm definition of data source, but it doesn't work.

Thanks, Carlo

[sven72]

That doesn't work with our Analysis version (2.6.3). If i'll try this, i'll loose the structure of the crosstabs.

My suggestion is (--> use the tab "Components" for all following steps):

Right click on file name / Log Off

Right click on file name / Replace System

Select new system on the right hand side

Right click on file name / Refresh All

Sven

[Former Member]

Unfortunately, it isn't a solution for me, since I've just one system (Hana cloud). On that system, I've packages for dev, test and production.

Thanks, Carlo

[TammyPowlas]

You should be able to change the data source on the components tab - I just tested this between a DEV and Production system and it worked for me in 2.7 - see above or below:

[Former Member]

Yes, I'm able to change data source on the components tab, but it will reset crosstabs structures! What I'm doing wrong? I've 2.7 version of Analysis for Office.

Thanks, Carlo

[TammyPowlas]

Carlo - my guess is it could be dependent on BW backend; you could also try Sven's suggestion below

[Boyan_P]

The solution that @TammyPowlas  provides here works.

Hoever you must keep in mind that ALL of your Design Rules will be Deleted! So make a BKP of the WB before changing the Source.

In case you have lots of cstom formats and rules ... youll have to manually transfer them from the backup WB.

Regards,
Boyan.