MDSCHEMA_SETS Rowset

MDSCHEMA_SETS Rowset

 

Applies To: SQL Server 2016 Preview

Describes any sets that are currently defined in a database, including session-scoped sets.

The MDSCHEMA_SETS rowset contains the following columns.

Column nameType indicatorDescription
CATALOG_NAMEDBTYPE_WSTRThe name of the database.
SCHEMA_NAMEDBTYPE_WSTRNot supported.
CUBE_NAMEDBTYPE_WSTRThe name of the cube.
SET_NAMEDBTYPE_WSTRThe name of the set, as specified in the CREATE SET statement.
SCOPEDBTYPE_I4The scope of the set:

 MDSET_SCOPE_GLOBAL (1)

 MDSET_SCOPE_SESSION (2)
DESCRIPTIONDBTYPE_WSTRNot supported.
EXPRESSIONDBTYPE_WSTRThe expression for the set.
DIMENSIONSDBTYPE_WSTRA comma delimited list of hierarchies included in the set.
SET_CAPTIONDBTYPE_WSTRA label or caption associated with the set. The label or caption is used primarily for display purposes.
SET_DISPLAY_FOLDERDBTYPE_WSTRA string that identifies the path of the display folder that the client application uses to show the set. The folder level separator is defined by the client application. For the tools and clients supplied by Analysis Services, the backslash (\) is the level separator. To provide multiple display folders, use a semicolon (;) to separate the folders.
SET_EVALUATION_CONTEXTDBTYPE_I4The context for the set. The set can be static or dynamic. This column can have one of the following values:

MDSET_RESOLUTION_STATIC=1

MDSET_RESOLUTION_DYNAMIC=2

The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME.

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

Column nameType indicatorRestriction State
CATALOG_NAMEDBTYPE_WSTROptional.
SCHEMA_NAMEDBTYPE_WSTROptional.
CUBE_NAMEDBTYPE_WSTROptional.
SET_NAMEDBTYPE_WSTROptional.
SCOPEDBTYPE_I4Optional.
HIERARCHY_UNIQUE_NAMEDBTYPE_WSTROptional.
CUBE_SOURCEDBTYPE_UI2Optional.

Note: Only one hierarchy can be included, and only those named sets whose hierarchies exactly match the restriction are returned.

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft