Export (0) Print
Expand All

MDSCHEMA_CUBES

SQL Server 2000

MDSCHEMA_CUBES

This schema rowset describes the structure of cubes that are contained in a database.

Microsoft® SQL Server™ 2000 Analysis Services extends the OLE DB specification with the addition of the following columns to this schema rowset.

Column name Type Description
IS_DRILLTHROUGH_ENABLED DBTYPE_BOOL Describes whether DRILLTHROUGH can be performed on the members of a cube
IS_WRITE_ENABLED DBTYPE_BOOL Describes whether a cube is write-enabled
IS_LINKABLE DBTYPE_BOOL Describes whether a cube can be used in a linked cube
IS_SQL_ALLOWED DBTYPE_BOOL Describes whether or not SQL can be used on the cube

In Analysis Services, the CUBE_TYPE column can contain one the following string values: "CUBE", "VIRTUAL CUBE", or "LINKED CUBE". The value of the column depends on the type of cube the row is describing.

For local cubes, this column contains "CUBE".

For more information about the variety of cubes supported by Analysis Services, see Introduction to Cubes.

Restriction Columns

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME

See Also

Regular Cubes

Virtual Cubes

Linked Cubes

Local Cubes

Show:
© 2014 Microsoft