Export (0) Print
Expand All

MDSCHEMA_SETS Rowset

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

The MDSCHEMA_SETS rowset contains the following columns.

Column name Type indicator Length Description

CATALOG_NAME

DBTYPE_WSTR

The name of the database.

SCHEMA_NAME

DBTYPE_WSTR

Not supported.

CUBE_NAME

DBTYPE_WSTR

The name of the cube.

SET_NAME

DBTYPE_WSTR

The name of the set, as specified in the CREATE SET statement.

SCOPE

DBTYPE_I4

The scope of the set:

  • MDSET_SCOPE_GLOBAL (1)
  • MDSET_SCOPE_SESSION (2)

DESCRIPTION

DBTYPE_WSTR

Not supported.

EXPRESSION

DBTYPE_WSTR

The expression for the set.

DIMENSIONS

DBTYPE_WSTR

A comma delimited list of hierarchies included in the set.

SET_CAPTION

DBTYPE_WSTR

A label or caption associated with the set. The label or caption is used primarily for display purposes.

SET_DISPLAY_FOLDER

DBTYPE_WSTR

The path to be used by the user interface when displaying the set. Folder names are separated by a backslash (\), folders are separated by a semicolon (;).

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 name Type indicator Restriction State

CATALOG_NAME

DBTYPE_WSTR

Optional.

SCHEMA_NAME

DBTYPE_WSTR

Optional.

CUBE_NAME

DBTYPE_WSTR

Optional.

SET_NAME

DBTYPE_WSTR

Optional.

SCOPE

DBTYPE_I4

Optional.

HIERARCHY_UNIQUE_NAME

DBTYPE_WSTR

Optional.

CUBE_SOURCE

DBTYPE_UI2

Optional.

Only one hierarchy can be included, and only those named sets whose hierarchies exactly match the restriction are returned.
ms126290.note(en-US,SQL.90).gifNote:

Community Additions

ADD
Show:
© 2014 Microsoft