Getting the Query Capabilities of a Universe (Web Intelligence)

Usage

Gets the query capabilities of a universe.

Request

GET /universes/<universeID>/capabilities

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 /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>
        ...
        <supportedLogicalOperators>or</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>