Getting the Capabilities of a BEx Query

Returns the capabilities of a BEx query.

Request

PUT <webiURL>/bwconnections/{bwConnectionId}/capabilities

Where:

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

Request body (optional):

<bwnode>
    <id>The BEx query identifier</id>
</bwnode>
Response

Response type: application/xml or application/json

Response body: the capabilities of a BEx query that you have the authorization to see/access.

Example

PUT <webiURL>/bwconnections/11990/capabilities

Request body in an XML file:

<bwnode>
    <id>11990;Z_BOBJ;ROLE_ST_BEX5</id>
</bwnode>

Response:

<datasource:QueryCapability xmlns:datasource="http://com.sap.sl.datasource">
    <generalCapability customQueryScriptSupported="false" showHideScopeSupported="false"/>
    <dataProcessingCapability removeEmptyRowsAvailable="true" maxRetrievalTimeAvailable="false"
        queryStrippingAvailable="true"/>
    <filterCapability resultHierarchyInFilterSupported="false" constantComparisonSupported="true"
        hierarchyConstantOperandSupported="true">
        <supportedComparisonOperators>equal</supportedComparisonOperators>
        <supportedComparisonOperators>notEqual</supportedComparisonOperators>
        <supportedComparisonOperators>inList</supportedComparisonOperators>
        <supportedComparisonOperators>notInList</supportedComparisonOperators>
        <supportedComparisonOperators>between</supportedComparisonOperators>
        <supportedComparisonOperators>notBetween</supportedComparisonOperators>
        <supportedComparisonOperators>greater</supportedComparisonOperators>
        <supportedComparisonOperators>greaterOrEqual</supportedComparisonOperators>
        <supportedComparisonOperators>less</supportedComparisonOperators>
        <supportedComparisonOperators>lessOrEqual</supportedComparisonOperators>
        <supportedValueBasedHierarchyComparisonOperators>equal
            </supportedValueBasedHierarchyComparisonOperators>
        <supportedValueBasedHierarchyComparisonOperators>inList
            </supportedValueBasedHierarchyComparisonOperators>
        <supportedLevelBasedHierarchyComparisonOperators>equal
            </supportedLevelBasedHierarchyComparisonOperators>
        <supportedLevelBasedHierarchyComparisonOperators>inList
            </supportedLevelBasedHierarchyComparisonOperators>
        <supportedLogicalOperators>and</supportedLogicalOperators>
        <supportedObjects>attribute</supportedObjects>
        <supportedObjects>dimension</supportedObjects>
        <supportedObjects>hierarchy</supportedObjects>
        <supportedObjects>level</supportedObjects>
    </filterCapability>
    <resultObjectCapability useAttributeSeparatelyAvailable="true" 
        buildLogicalSetWithMetadataFunctionsAvailable="true"
        buildLogicalSetWithMemberFunctionsAvailable="true" memberSelectionPromptSupported="true"
        supportsMemberSelectionCompletion="true"/>
</datasource:QueryCapability>