Migrating Webi report from one environment to another using .Net SDK

[Former Member]

Hi,

We have move to BI 4.1 version from BI 3.1 version. We are updating our .Net code for migrating Webi reports from one evironment to another(say QA to UAT). We need some samples or Links for the same.

Thanks in advance.

Regards,

Roque

[Former Member · Accepted solution]

Hi Roque,

Please go thorugh the following link , it will give you some useful insight

http://scn.sap.com/docs/DOC-53285

samples

http://wiki.scn.sap.com/wiki/display/BOBJ/NET+RAS+SDK+Samples?original_fqdn=wiki.sdn.sap.com

Regards

Ganesh

[Former Member · Accepted solution]

Thanks Ganesh....

[Former Member]

We are using below code to get copy of object that is used for migrating report from one environment to another

static InfoObject MigrateInfoObject(BOEnvironment source, BOEnvironment target, BODatabaseNames dbQueryTableName, InfoObject sourceInfoObj, MigrationOption option)

try

InfoObjects infoObjects = GetNewInfoObjectCollection(target);

InfoObject copiedInfoObj = infoObjects.Copy(sourceInfoObj, CeCopyObject.ceCopyNewObjectKeepRUID);

int idParentObjInTarget = GetParentObjID(source, target, dbQueryTableName, GetInfoObjByCUID(source, ResultType.BaseInfo, dbQueryTableName, ObjectKind.Any, sourceInfoObj.ParentCUID));

if (idParentObjInTarget == -1)

throw new BOObjectNotFoundExpection(target, sourceInfoObj.ParentCUID, BOExpectionObjectRefType.CUID);

ResultType.BaseInfo, dbQueryTableName, ObjectKind.Any, sourceInfoObj.ParentCUID));

"InfoObject (" + copiedInfoObj.Title + "): Updated it parent InfoObject association on " + target.FullEnvironmentName);

if (option.RetainOwnerInfo)

BOConst.COM_OWNERID].Value = UserGroupManager.GetUserByName(target, sourceInfoObj.Properties[BOConst.COM_OWNER].Value.ToString()).ID;

return copiedInfoObj;

catch (Exception ex)

string errorMsg = "Failed to migrate object '" + sourceInfoObj.Title + "' to " + target.FullEnvironmentName + " with error message: " + ex.Message;

throw (new Exception(errorMsg));

This code works for crystal report. But for Webi, infoObjects.Copy gives error:

BusinessObjects.DSWS.BIPlatform.Desktop.InfoObjects' does not contain a definition for 'Copy' and no extension method 'Copy' accepting a first argument of type 'BusinessObjects.DSWS.BIPlatform.Desktop.InfoObjects' could be found (are you missing a using directive or an assembly reference?)