Imagine the following scenario:

• You have a 3-layer BOXI Server architecture. (BOXI_DEV, BOXI_TEST and BOXI_PROD)

  

• You are using Web Intelligence instances for data aggregation and some kind of transformation.
• You have several Xcelsius Dashboards which connects via LiveOffice to the Web Intelligence Layer to refresh data

The migration of this quite complex architecture is not banal. So how would we migrate those files from one server to another server? (e.g. from BOXI_DEV to BOXI_TEST)

1. Migrate the WebI reports via the import assitant to the new server.
2. Change the Webservice-URL of the LiveOffice connections in all Xcelsius files and deploy them to the target BOXI server.
3. Test the migration result on the target system.

The key to success is to know, that LiveOffice connects to the WebI-Reports using the Webservice-URL and the CUID of the embedded object (WebI report) despite in LiveOffice properties it is indicated that LiveOffice connect to the regarding object via %Path%/%Object Name%. (see below) It is non-transparent for the developer that LiveOffice uses the CUID of the object instead of the path and object name during runtime.

So when migrating the WebI report objects to the target server you have to ensure that the CUID of the objects stay the same, otherwise migration will fail!

To ensure, that the CUID of the objects will remain stable you have to use the following import scenario with your import assistant utility:

If the object is still existing, the imported object will be renamed. That's no problem, because LiveOffice connect to the CUID. Eventual renaming has just a cosmetic effect. Ensure that the object IDs of the source system and the target system remain stable, and check this by viewing the object properties in CMC or InfoView:

After successfully migrating the WebI reports to the target environment you have reschedule your instances and redeploy the Dashboards. Before you deploy your Dashboards to the target system, ensure to reconfigure the Webservice-URL, otherwise the Dashboards will connect to the "old" system.

You can either enter the Webservice-URL into the input field of the Xcelsius Data Manager or you can enter a fixed cell reference of the currently used Webservice-URL. The advantage of the second way is, that you just have to change the values in the binded cell (e.g. $B$42). So maintenance of your Dashboard is much easier.

Now you can reploy your Dashboard to the target server.

Best practice would be to fill the binded Webservice-URL cell with a FlashVar so you can tell your Dashboard via a HTTP parameter which server shall be used. When using a FlashVar for Webservice-URL you do not even have to redeploy your Dashboard and can simply migrate the SWF file via import assistant to the target environment.

Last but not least i would recommand to deselect the Enterprise Authentication options of LiveOffice in Excel, which might confuse you while migrating your connections.