Browsing the Details of an SAP BW connection

Browses the details of an incomplete SAP BW connection and helps you choose a BEx query which will complete the connection.

The "by path" and "by search pattern" browsing methods are available.

Note Only MDX compliant BEx queries are usable in Web Intelligence workflows.
Request

PUT <webiURL>/bwconnections/{bwConnectionId}

Where:

  • {bwConnectionId} is the connection identifier retrieved from the list of SAP BW connections

Request body (optional):

  • By path:
    <bwnode>
        <path>[path/to/the/required/node]</path>
    </bwnode>
  • By search pattern:
    <bwnode>
        <pattern>[pattern to be used for the search]</pattern>
    </bwnode>
Response

Response type: application/xml or application/json

Response body: the list of BW connections that you have the authorization to access.

Note A BEx query identifier is defined by the concatenation of the BW connection identifier and the technical name of the BEx query, separated by a semi-colon (;).

Example

1: To get the list of BEx queries inside a BW connection, browsing by path

PUT <webiURL>/bwconnections/11990

Request body in an XML file:

<bwnode>
    <path>/SystemInfoareaTopLevel/BUSINESSOBJECTS_QA/Z_BOBJ/TEST_DATE</path>
</bwnode>

Response:

<bwconnection type="System">
    <id>11990</id>
    <cuid>Aaj0N_I.bSJElyDKk08sxTU</cuid>
    <name>raylight_BOF</name>
    <folderId>11484</folderId>
    <bwnodes>
        <bwnode type="Query">
            <id>11990;TEST_DATE</id>
            <name>test_data</name>
            <technicalName>TEST_DATE</technicalName>
            <mdxCompliant>true</mdxCompliant>
            <path>/SystemInfoareaTopLevel/BUSINESSOBJECTS_QA/Z_BOBJ/TEST_DATE</path>
        </bwnode>
    </bwnodes>
</bwconnection>

Example

To get the list of BEx queries inside a BW connection matching a pattern

PUT <webiURL>/bwconnections/11990

Request body in an XML file:

<bwnode>
    <pattern>*BOBJ*</pattern>
</bwnode>

Response:

<bwconnection type="System">
    <id>11990</id>
    <cuid>Aaj0N_I.bSJElyDKk08sxTU</cuid>
    <name>raylight_BOF</name>
    <folderId>11484</folderId>
    <bwnodes>
        <bwnode type="Query">
            <id>11990;Z_BOBJ;BOBJ_TEST_ROLE</id>
            <name>BOBJ_TEST_ROLE</name>
            <technicalName>BOBJ_TEST_ROLE</technicalName>
            <mdxCompliant>false</mdxCompliant>
        </bwnode>
        <bwnode type="Query">
            <id>11990;Z_BOBJ;IE_ZBOBJ_COUNTRYVAR</id>
            <name>IE_ZBOBJ_COUNTRYVAR</name>
            <technicalName>IE_ZBOBJ_COUNTRYVAR</technicalName>
            <mdxCompliant>true</mdxCompliant>
        </bwnode>
        <bwnode type="Query">
            <id>11990;T_BOBJ;ZCR_BOBJ_ALLF_MHIER_FCHAR_1</id>
            <name>ZCR BOBJ all_fields mult_hier free_chars</name>
            <technicalName>ZCR_BOBJ_ALLF_MHIER_FCHAR_1</technicalName>
            <mdxCompliant>false</mdxCompliant>
        </bwnode>
        <bwnode type="Query">
            <id>11990;Z_BOBJ;Z_BOBJ_HB_SIMPLE</id>
            <name>Z_BOBJ_HB_simple</name>
            <technicalName>Z_BOBJ_HB_SIMPLE</technicalName>
            <mdxCompliant>true</mdxCompliant>
        </bwnode>
    </bwnodes>
</bwconnection>