Exchange of Metadata in XML Format According to CWM 

Use

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

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 Transport 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.

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

SAP/BW/XML/CWM?...

<Class>

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

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

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.

      • 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.

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:

 Import from another system

 Export into another system

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.

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