Getting the Query Capabilities of a Universe (Semantic Layer)

Usage

Gets the query capabilities of a UNX or UNV universe, depending on the user rights.

These capabilities list the features supported by the data source when building the query from the query panel.

Request

GET /universes/<universeID>/capabilities

Request type: application/xml

Response

Response type: application/xml

Response body:

Capabilities Feature Description
General query capabilities <combinedQueriesSupported> true if the data source supports the combined queries.
<maxValuesForInList> The maximum number of items that can be set in a filter based on INLIST or NOT_INLIST operators.
Data processing capabilities <removeDuplicateRowsAvailable>  
<samplingLevel>  
<maxRowRetrievedAvailable>  
<maxRetrievalTimeAvailable>  
Filter capabilities <supportedComparisonOperators> The list of comparison operators supported for filters based on dimensions, attributes or measures.
<supportedLogicalOperators> The list of logical operators supported to combine filters.
<supportedObjects> The list of object qualifications (dimensions, attributes, and measures) supported to build queries.
<supportedRankings> The list of supported ranking operators (top, bottom, topPercent, or bottomPercent)
<resultObjectInFilterSupported> true if an object used as a result object can be used in a filter.
<objectComparisonSupported> true if filter operands based on another object are supported.
<constantComparisonSupported> true if filter operands based on constant values are supported.
<subQueriesSupported> true if subquery filters are supported.
Result object capabilities <useAttributeSeparatelyAvailable>  
<sortObjectsAvailable> true if query sorts from objects are supported.
<sortNonResultObjectsAvailable> true if query sorts from objects that are not used as result objects are supported.

Example

GET /universes/5808/capabilities

<capabilities xmlns="http://www.sap.com/rws/sl/universe">
    <GeneralCapabilities>
        <combinedQueriesSupported>true</combinedQueriesSupported>
        <maxValuesForInList>-1</maxValuesForInList>
    </GeneralCapabilities>
    <DataProcessingCapabilities>
        <removeDuplicateRowsAvailable>true</removeDuplicateRowsAvailable>
        <samplingLevel>None</samplingLevel>
        <maxRowRetrievedAvailable>true</maxRowRetrievedAvailable>
        <maxRetrievalTimeAvailable>true</maxRetrievalTimeAvailable>
    </DataProcessingCapabilities>
    <filterCapabilities>
        <supportedComparisonOperators>
            <value>EqualTo</value>
            <value>NotEqualTo</value>
            <value>Between</value>
            <value>NotBetween</value>
            ...
        </supportedComparisonOperators>
        <supportedRankings>
            <value>top</value>
            <value>bottom</value>
            <value>topPercent</value>
            <value>bottomPercent</value>
        </supportedRankings>
        <supportedLogicalOperators>
            <value>or</value>
            <value>and</value>
        </supportedLogicalOperators>
        <supportedObjects>
            <value>attribute</value>
            <value>dimension</value>
            <value>measure</value>
            <value>filter</value>
        </supportedObjects>
        <subQueriesSupported>true</subQueriesSupported>
        <resultObjectInFilterSupported>true</resultObjectInFilterSupported>
        <objectComparisonSupported>true</objectComparisonSupported>
        <constantComparisonSupported>true</constantComparisonSupported>
    </filterCapabilities>
    <ResultObjectCapabilities>
        <useAttributeSeparatelyAvailable>true</useAttributeSeparatelyAvailable>
        <sortObjectsAvailable>true</sortObjectsAvailable>
        <sortNonResultObjectsAvailable>false</sortNonResultObjectsAvailable>
    </ResultObjectCapabilities>
</capabilities>