Dashboard Migrations - easy for admin and developers?

[#1]

Hi I've read the SAP wiki on migrating dashboards and am still not sure how to proceed in the most smooth manner.

How to Migrate and Upgrade Dashboards - Business Intelligence (BusinessObjects) - SCN Wiki

You can find my version information in my signature - 3.1 SP3. 

I have two issues

1. Migrating QaaWS:  When migrating the qaaws queries using the import/export wizard, the web service url host is still pointing to our development web service URL.  This causes me to have to edit every query, get the dialog that asks if I'd like to use the new host and then step through the wizard to publish the URL.  This is a lengthy process.  The instructions make it seems as if you are done after running the wizard and no further action is needed.
2. Migrating SWF:  We don't have LCM installed, so I gather we need to use option 1, which is also recommended.  However using a relative path for the URL seems like it will cause problems.  First, the developers will not be able to preview their dashboards - so each time they deploy to development, they need to update every single data connection.  Second, the web service is hosted on a different server than our infoview/boxi web/app server. 

We have a dashboard with about 60 QaaWS queries, so this has become very painful to fix.  Our initial move took several hours, which makes it seem like we are doing something very wrong.

Thanks for any help.

Sam

[sapanesh_agnihotri]

Hi Sam,

Did you tried flash player method as well?

Migration of dashboards using Flash Variables

This method requires you to consider the below steps while you are designing the dashboards.

One thing we have recommended with QaaWS in the past is to try to design your dashboard to make it easier to point to a different server.

What you can do is:

1. For each QaaWS Web Service connection, copy the Web Service URL and put it into the spreadsheet using this format:

   =<URL>

   Using the "=" syntax makes it a formula that we can edit later.
2. Bind the Web Service URL to each cell (one per query)
3. In Excel, take the server name from one of the cells and put that in its own cell (e.g., A1)
4. Update each of the URL cells to refer to the cell created in step 3.

   =A1&<rest of the URL here>

5. Define a Flash Variable to pass in the server name
6. Once you publish the SWF to the BI platform, you may change the Flash Variable value for a specific dashboard using the CMC\\\\

Thanks,
Sapanesh

[Former Member]

That option listed LCM as a prerequisite, so I did not consider it.  Do you have experience that it will work using the import wizard?