Using XML Import/Export in Transport Connection

[#1]

Hi, I was investigating the feasibility of copying a query definition from one BW system to another using the XML Import/Export functionality in Transport Connection. This is not to replace our current transport process across the landscape (Dev -> QA -> Prod), but merely just looking at possibilities for end users who develop queries in QA & then recreate them in Prod.

My question is: has anyone worked with the XML Export/Import for types Queries & Query Elements? I was trying this out between a Dev and Sandbox system and only had limited success. I was able to take a small query and perform the Export to a local .xml file without much difficulty. But when I try to do the Import, my query never shows up. The Import function shows a green light, but I get a couple of error messages on the Import such as the following:

==========================================================

SAP object 3WROG4HZ3NKP1PIYHCR1H24CQ () cannot be imported

Diagnosis

-

---

You attempted to import SAP object 3WROG4HZ3NKP1PIYHCR1H24CQ of type into the system via the XMI interface. However, you are not allowed to import SAP objects.

System response

-

---

The object was ignored during the import.

Note: It can be that the import is incomplete when the required SAP objects are still not active in the system.

Procedure

-

---

Install the specified objects from Business Content. Only import the metadata afterwards.

=========================================================

The portion returned for Saving and Activating returns green lights. The two sample objects mentioned appear to just be custom InfoObjects used in my query & don't look to be any different than others that work OK.

Just curious if anyone else has worked with this and could help advise.

Thanks... Jody

[Former Member]

Hi

Do any one has any clues on why the import does not show the actual object....

[Former Member]

This is an old subject, but I think XML import only works for datamodeling objects like InfoObjects, InfoCubes, and ODS objects. If you try to export a query, and open the XML file in a text editor, there is not enough information (in my opinion) to build the query. As an example you don't see how key figures are to be displayed, filter or free characteristics.

However, when an InfoObject is collected, you get all the attributes, texts in all languages.

If anyone has more insight, please enlighten us.

-John

[Former Member]

I also had tried the XML Import/Export. The Export worked succesfully and created the local XML file, but when I tried to import the object everything was showing green, but could not find the imported object in the destination system. Not sure how this works.

Thanks.

[Former Member]

Thanks Deepu... perhaps someone else has been successful & can share their insights.

Jody