Getting the Query Capabilities of a Universe

Gets the query capabilities of a universe.

Request

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

Where:

  • {universeId} is the universe identifier
Response

Response type: text/xml

Response body: the following capabilities of a universe, depending on the user rights:

  • General query capabilities
  • Data processing capabilities
  • Filter capabilities: subqueries supported, result hierarchy in filter, object comparison, constant comparison, query on query, and the following lists:
    • The list of supported comparison operators
    • The list of supported logical operators
    • The list of supported object types
    • The list of query on query supported comparison operators
  • Result object capabilities

Example

GET <webiURL>/universes/2234/capabilities

<datasource:QueryCapability xmlns:datasource="http://com.sap.sl.datasource">

<generalCapability combinedQueriesSupported="true" viewQueryScriptAvailable="true" maxValuesForInList="999"/>

<dataProcessingCapability removeDuplicateRowsAvailable="true"/>

<filterCapability subQueriesSupported="true" resultHierarchyInFilterSupported="false" objectComparisonSupported="true" constantComparisonSupported="true" queryOnQuerySupported="true">		
    <supportedComparisonOperators>equal</supportedComparisonOperators>
    <supportedComparisonOperators>notEqual</supportedComparisonOperators>
    <supportedComparisonOperators>between</supportedComparisonOperators>	
    <supportedComparisonOperators>notBetween</supportedComparisonOperators>
    ...
    <supportedLogicalOperators>or</supportedLogicalOperators>	
    <supportedLogicalOperators>and</supportedLogicalOperators>	

    <supportedObjects>attribute</supportedObjects>
    <supportedObjects>dimension</supportedObjects>
    <supportedObjects>measure</supportedObjects>	

    <queryOnQueryCapability>	
        <supportedCorrelationTypesByComparisonOperator>
            <value>Any</value>
        </supportedCorrelationTypesByComparisonOperator>	
        <supportedCorrelationTypesByComparisonOperator key="notEqual">		
            <value>All</value>	
        </supportedCorrelationTypesByComparisonOperator>	
        <supportedCorrelationTypesByComparisonOperator key="greater">	
            <value>Any</value>
            <value>All</value>
        </supportedCorrelationTypesByComparisonOperator>	
        ...
        <supportedCorrelationTypesByComparisonOperator key="between"/>
        <supportedCorrelationTypesByComparisonOperator key="notBetween"/>		
        <supportedCorrelationTypesByComparisonOperator key="inList">	
            <value>None</value>
        </supportedCorrelationTypesByComparisonOperator>	
        ...    
        <supportedComparisonOperatorsByCorrelationType>	
            <value>inList</value>
   		       <value>notInList</value>	
        </supportedComparisonOperatorsByCorrelationType>	
        <supportedComparisonOperatorsByCorrelationType key="All">	  
            <value>greater</value>
            <value>greaterOrEqual</value>	
            <value>less</value>	
            <value>lessOrEqual</value>	
            <value>notEqual</value>
        </supportedComparisonOperatorsByCorrelationType>
        ...
    </queryOnQueryCapability>	

    <subQueryCapability>
        <supportedCorrelationTypesByComparisonOperator>
            <value>Any</value>
        </supportedCorrelationTypesByComparisonOperator>
        <supportedCorrelationTypesByComparisonOperator key="notEqual">
            <value>Any</value>
    	       <value>All</value>
        </supportedCorrelationTypesByComparisonOperator>
        <supportedCorrelationTypesByComparisonOperator key="greater">
            <value>Any</value>	
            <value>All</value>	
        </supportedCorrelationTypesByComparisonOperator>	
        ...
        <supportedCorrelationTypesByComparisonOperator key="isNull"/>	
        <supportedCorrelationTypesByComparisonOperator key="notIsNull"/>
        <supportedCorrelationTypesByComparisonOperator key="like"/>
        ...
        <supportedComparisonOperatorsByCorrelationType key="All">	
            <value>greater</value>
            <value>greaterOrEqual</value>
    	       <value>less</value>
            <value>lessOrEqual</value>
            <value>equal</value>
        </supportedComparisonOperatorsByCorrelationType>
        ...    
    </subQueryCapability>
</filterCapability>

<resultObjectCapability useAttributeSeparatelyAvailable="true" sortObjectsAvailable="true" sortNonResultObjectsAvailable="true"/>

</datasource:QueryCapability>