Browsing the Details of an SAP BW connection

Browses the details of an incomplete SAP BW connection.

This URL allows you to choose a BEx query which will complete the connection. Two browse methods are available: by path and find by pattern.

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):

  • For a path:
    <bwnode>
        <path>[path/to/the/required/node]</path>
    </bwnode>
  • For a 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 see/access.

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>
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 (;).