Getting the Query Capabilities of a Universe (Semantic Layer)

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

Request

GET <slURL>/universes/{universeId}/capabilities

Where:

  • {universeId} is the universe identifier retrieved from the list of universes
Response

Response type: application/xml

Response body:

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

Example

GET <slURL>/universes/5808/capabilities

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<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>
        <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>