Getting the Capabilities of a BEx Query

Usage

Returns the capabilities of a BEx query.

Request

PUT /bwconnections/<bwConnectionID>/capabilities

Request body (optional):

<bwnode>
    <id>

Where:

  • <id> is the BEx query identifier
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 /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>
        ...
        <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>