UniverseCapabilities
Query universe capabilities for a SAP Business Objects BI instance.
Select
The following queries are processed server-side:
SELECT * FROM UniverseCapabilities
SELECT * FROM UniverseCapabilities WHERE Id=1
Columns
| Name | Type | Description |
| Id [KEY] | Integer | The universe ID. |
| GeneralCapabilities_MaxValuesForInList | Integer | Max number of values for IN value list. |
| GeneralCapabilities_CombinedQueriesSupported | Bool | If combined queries are supported. |
| GeneralCapabilities_ViewQueryScriptAvailable | Bool | If view query script is available. |
| GeneralCapabilities_CustomQueryScriptSupported | Bool | If view custom query script is supported. |
| GeneralCapabilities_ContextMultipleSelectionSupported | Bool | If context multiple selection is supported. |
| GeneralCapabilities_ShowHideScopeSupported | Bool | If show hide scope is supported. |
| DataProcessingCapabilities_SamplingLevel | String | The sampling level. |
| DataProcessingCapabilities_RemoveDuplicateRowsAvailable | Bool | If remove duplicate rows is available. |
| DataProcessingCapabilities_MaxRowRetrievedAvailable | Bool | If max row retrieved is available. |
| DataProcessingCapabilities_MaxRetrievalTimeAvailable | Bool | If max row retrieval time is available. |
| DataProcessingCapabilities_RemoveEmptyRowsAvailable | Bool | If remove empty rows is available. |
| DataProcessingCapabilities_QueryStrippingAvailable | Bool | If query stripping is available. |
| ResultObjectCapabilities_UseAttributeSeparatelyAvailable | Bool | If use attribute separately is available. |
| ResultObjectCapabilities_SortObjectsAvailable | Bool | If sort objects is available. |
| ResultObjectCapabilities_SortNonResultObjectsAvailable | Bool | If sort non result objects is available. |
| ResultObjectCapabilities_MultipleIntraDimensionalHierarchiesSupported | Bool | If multiple intra dimensional hierarchies is supported. |
| ResultObjectCapabilities_BuildLogicalSetWithMetadataFunctionsAvailable | Bool | If build logical set with metadata functions is available. |
| ResultObjectCapabilities_BuildLogicalSetWithMemberFunctionsAvailable | Bool | If build logical set with member functions is available. |
| ResultObjectCapabilities_MemberSelectionPromptSupported | Bool | If member selection prompt is supported. |
| ResultObjectCapabilities_SupportsMemberSelectionCompletion | Bool | If member selection completion is supported. |
| FilterCapabilities_SubQueriesSupported | Bool | If sub queries are supported. |
| FilterCapabilities_ResultObjectInFilterSupported | Bool | If result object in filter is supported. |
| FilterCapabilities_ObjectComparisonSupported | Bool | If object comparison is supported. |
| FilterCapabilities_ConstantComparisonSupported | Bool | If constant comparison is supported. |
| FilterCapabilities_ResultHierarchyInFilterSupported | Bool | If result hierarchy in filter is supported. |
| FilterCapabilities_QueryOnQuerySupported | Bool | If query on query is supported. |
| FilterCapabilities_FreeValuesForMultiValuesPromptSupported | Bool | If free values for multi values prompt is supported. |
| FilterCapabilities_HierarchyConstantOperandSupported | Bool | If hierarchy constant operand is supported. |
| FilterCapabilities_MultipleIntraDimensionalHierarchiesInFilterSupported | Bool | If multiple intra dimensional hierarchies in filter is supported. |
| FilterCapabilities_SupportedComparisonOperators | String | The list of supported comparison operators. |
| FilterCapabilities_SupportedLogicalOperators | String | The list of supported logical operators. |
| FilterCapabilities_SupportedObjects | String | The list of supported objects. |
| FilterCapabilities_SupportedRankings | String | The list of supported rankings. |
| FilterCapabilities_SupportedValueBasedHierarchyComparisonOperators | String | The list of supported value based hierarchy comparison operators. |
| FilterCapabilities_SupportedLevelBasedHierarchyComparisonOperators | String | The list of supported level based hierarchy comparison operators. |