Applies To: SQL Server 2016 Preview

Returns a list of names, data types, and enumeration values of enumerators supported by the Microsoft XML for Analysis (XMLA) provider for a specific data source. The XMLA Provider publishes all the enumeration constants that it recognizes.

If you call the Discover method with the DISCOVER_ENUMERATORS enumeration value in the RequestType element, the Discover method returns the DISCOVER_ENUMERATORS schema rowset.

For each enumerator, there are multiple elements, one for each value in the enumeration. The rowset that represents each enumerator is flat, and the name of the enumerator may be repeated for elements belonging to the same enumeration.

The DISCOVER_ENUMERATORS rowset contains the following columns.

Column nameType indicatorLengthDescription
EnumNameDBTYPE_WSTRThe name of the enumerator that contains a set of values.
EnumDescriptionDBTYPE_WSTRA localizable description of the enumerator. Can be NULL.
EnumTypeDBTYPE_WSTRThe data type of the enumeration values.
ElementNameDBTYPE_WSTRThe name of one of the value elements in the enumerator set.

Example: TDP
ElementDescriptionDBTYPE_WSTR(Optional) A localizable description of the element. Can be NULL.
ElementValueDBTYPE_WSTRThe value of the element. Can be NULL.

Example: 01

This schema rowset is not sorted.

The DISCOVER_ENUMERATORS rowset can be restricted on the columns listed in the following table.

Column nameType indicatorRestriction State

XML for Analysis Schema Rowsets

Community Additions