Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

MDSCHEMA_CELL_FORMULAS

SQL Server 2000

MDSCHEMA_CELL_FORMULAS

Microsoft® SQL Server™ 2000 Analysis Services extends the OLE DB specification with the addition of the MDSCHEMA_CELL_FORMULAS schema rowset. The following table describes this schema rowset.

Column name Type Description
CATALOG_NAME DBTYPE_WSTR The name of the catalog to which a set belongs. If the provider does not support catalogs, this column contains VT_NULL.
SCHEMA_NAME DBTYPE_WSTR The name of the schema to which a calculated cell formula belongs. This column is not supported by Analysis Services. It always contains VT_NULL.
CUBE_NAME DBTYPE_WSTR The name of the cube to which the calculated cell formula belongs.
FORMULA_NAME DBTYPE_WSTR The name of the calculated cell formula, as specified in the CREATE CELL FORMULA statement.
SCOPE DBTYPE_I4 The scope of the calculated cell formula. Only MDSET_SCOPE_SESSION is supported. The calculated cell formula lasts only as long as the current session is active.
DESCRIPTION DBTYPE_WSTR A user-friendly description of the calculated cell formula. This column is not supported by Analysis Services. It always contains VT_NULL.
EXPRESSION DBTYPE_WSTR The Multidimensional Expressions (MDX) expression specified in the <formula body> clause of the CREATE CELL FORMULA statement.

Restriction Columns

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
FORMULA_NAME
SCOPE

See Also

Calculated Cells

CREATE CELL CALCULATION Statement

Show:
© 2015 Microsoft