The PROPERTIES schema rowset returns metadata about the properties
that are available on each level and the member that can be accessed
by the provider. Each row in the PROPERTIES schema rowset corresponds
to one property that is available in the provider.
The following
table describes the columns that are available in the PROPERTIES schema
rowset.
Standard Mapping
|
|
|
|
|
|
|
|
Type of this
property. Either MDPROP_MEMBER or MDPROP_CELL.
|
|
|
|
|
Name of the catalog
that contains this property.
|
|
|
|
|
Name of the schema
that contains this property.
|
|
|
|
|
Name of the cube
that contains this property.
|
|
|
|
|
Unique name of
the dimension that contains this property.
|
|
|
|
|
Unique name of
the hierarchy that contains this property.
|
|
|
|
|
Unique name of
the level that contains this property.
|
|
|
|
|
Unique name of
the member that contains this property.
|
|
|
|
|
|
|
|
|
|
Caption of this
property.
|
|
|
|
|
Data type of
this property.
|
|
|
|
|
Maximum length
of this property for character, binary, and bit properties if one
of these properties is defined. The value is 0 for character, binary,
and bit properties that do not have a defined maximum length. The
value is NULL for all other properties.
|
|
|
|
|
Maximum length
in octets of this property for character, binary, and bit properties
if one of these properties is defined. The value is 0 for character,
binary, and bit properties that do not have a defined maximum length.
The value is NULL for all other properties.
|
|
|
|
|
Maximum numeric
precision for numeric properties. NULL for all other properties.
|
|
|
|
|
Number of digits
to the right of the decimal point for numeric properties. NULL for
all other properties.
|
|
|
|
|
Description of
this property.
|
|