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.
GET /universes/<universeID>/capabilities
Request type: application/xml
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. |
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>