Function documentation Exchange of Metadata in XMI Format Locate the document in its SAP Library structure

Use

In order to exchange metadata (BW objects) between different systems, you can use the XMI format in the Administrator Workbench functional area Transport Connection. In doing so, one of the models derived according to the CWM (Common Warehouse Metamodel) is used.

Note

You can find additional information about the CWM standard on the OMG (Object Management Group) homepage: www.omg.org.

You can find additional information about the Administrator Workbench function area Transport Connection under Structure linkTransport Systems.

Integration

You can export or import the XML files (Download or Upload for PC) by using the Administrator Workbench.

Furthermore, an HTTP service is available under SAP/BW/XML/CWM. You can request this metadata in the way that you would like from a Web server by using this HTTP service. In order to request metadata for an object, use the following URL:

http://<Server>:Port/SAP/BW/XML/CWM?/CLASSID=<Klasse>&ID=<Name>&DETAIL=X&OBJECTVERSION=A

You have the following expressions for substitution:

Term

Information

<Server>:Port

Specify the name of the server and the port for the BW system you want.

Example

http://LS0027.WDF.SAP-AG.DE:1080/

SAP/BW/XML/CWM?...

<Class>

Specify the name of the class for the BW object you want.

Example

As an example for the class InfoCube: CLASSID=COM.SAP.BW.CWM.OLAP.INFOCUBE

Note

You get the BW model in XML format by using the following URL:

http://<Server>:Port/SAP/BW/XML/CWM?

CLASSID=METAMODEL

<Name>

Specify the technical name for the BW object you want.

Recommendation
      • You get an Overview of All Objects by using the following:

http://<Server>:Port/SAP/BW/XML/CWM?

CLASSID=LIST&ID=&DETAIL=&OBJECTVERSION=A
      • You get an Overview of All Business Content Objects by using the parameter &OBJECTVERSION=D, namely

http://<Server>:Port/SAP/BW/XML/CWM?

CLASSID=LIST&ID=&DETAIL=&OBJECTVERSION=A
      • You get an Overview of All Objects of a Specific Type by using the ID specifications in the URL.

Example

For example, you specify the following for InfoCubes:

http://<Server>:Port/SAP/BW/XML/CWM?

CLASSID=LIST&ID=COM.SAP.BW.CWM.OLAP.INFOCUBE

&DETAIL=&OBJECTVERSION=A

Functions

The exchange of metadata includes:

This graphic is explained in the accompanying text Import from another system

This graphic is explained in the accompanying text Export into another system

Recommendation

The objects that also exist for BAPIs (Business Application Programming Interfaces) are supported with details. You can only import these objects after you have changed them. You are still unable to import non-BW objects.

You can export the current BW model according to the XMI (XML Metadata Interchange) standard. This is possible by using the SAP report RSO_REPOSITORY_EXCHANGE_XML.

Note

You can find additional information about the XMI standard on the OMG homepage: www.omg.org.

The following graphic illustrates the functions EXPORT and IMPORT.

This graphic is explained in the accompanying text