.png)
MDSCHEMA_PROPERTIES Rowset
Describes the properties of members within a database.
The MDSCHEMA_PROPERTIES rowset contains the following columns.
Column name | Type indicator | Length | Description |
|---|---|---|---|
CATALOG_NAME | DBTYPE_WSTR | The name of the database. | |
SCHEMA_NAME | DBTYPE_WSTR | The name of the schema to which this property belongs. NULL if the provider does not support schemas. | |
CUBE_NAME | DBTYPE_WSTR | The name of the cube. | |
DIMENSION_UNIQUE_NAME | DBTYPE_WSTR | The unique name of the dimension. For providers that generate unique names by qualification, each component of this name is delimited. | |
HIERARCHY_UNIQUE_NAME | DBTYPE_WSTR | The unique name of the hierarchy. For providers that generate unique names by qualification, each component of this name is delimited. | |
LEVEL_UNIQUE_NAME | DBTYPE_WSTR | The unique name of the level to which this property belongs. If the provider does not support named levels, it should return the DIMENSION_UNIQUE_NAME value for this field. For providers that generate unique names by qualification, each component of this name is delimited. | |
MEMBER_UNIQUE_NAME | DBTYPE_WSTR | The unique name of the member to which the property belongs. Used for data stores that do not support named levels or have properties on a member-by-member basis. If the property applies to all members in a level, this column is NULL. For providers that generate unique names by qualification, each component of this name is delimited. | |
PROPERTY_TYPE | DBTYPE_I2 | A bitmap that specifies the type of the property:
| |
PROPERTY_NAME | DBTYPE_WSTR | The name of the property. If the key for the property is the same as the name for the property, PROPERTY_NAME will be blank. | |
PROPERTY_CAPTION | DBTYPE_WSTR | A label or caption associated with the property, used primarily for display purposes. Returns PROPERTY_NAME if a caption does not exist. | |
DATA_TYPE | DBTYPE_UI2 | The data type of the property. | |
CHARACTER_MAXIMUM_LENGTH | DBTYPE_UI4 | The maximum possible length of the property, if it is a character, binary, or bit type. Zero indicates there is no defined maximum length. Returns NULL for all other data types. | |
CHARACTER_OCTET_LENGTH | DBTYPE_UI4 | The maximum possible length (in bytes) of the property, if it is a character or binary type. Zero indicates there is no defined maximum length. Returns NULL for all other data types. | |
NUMERIC_PRECISION | DBTYPE_UI2 | The maximum precision of the property, if it is a numeric data type. Returns NULL for all other data types. | |
NUMERIC_SCALE | DBTYPE_I2 | The number of digits to the right of the decimal point, if it is a DBTYPE_NUMERIC or DBTYPE_DECIMAL type. Returns NULL for all other data types. | |
DESCRIPTION | DBTYPE_WSTR | A human readable description of the property. NULL if no description exists. | |
PROPERTY_CONTENT_TYPE | DBTYPE_I2 | The type of the property. Can be one of the following enumerations:
| |
SQL_COLUMN_NAME | DBTYPE_WSTR | The name of the property used in SQL queries from the cube dimension or database dDimension. | |
LANGUAGE | DBTYPE_UI2 | The translation expressed as an LCID. Only valid for property translations. | |
PROPERTY_ORIGIN | DBTYPE_UI2 | Identifies the type of hierarchy that the property applies to:
| |
PROPERTY_ATTRIBUTE_HIERARCHY_NAME | DBTYPE_WSTR | The name of the attribute hierarchy sourcing this property. | |
PROPERTY_CARDINALITY | DBTYPE_WSTR | The cardinality of the property. Possible values include the following strings:
| |
MIME_TYPE | DBTYPE_WSTR | The mime type for binary large objects (BLOBs). | |
PROPERTY_IS_VISIBLE | DBTYPE_BOOL | A Boolean that indicates whether the property is visible. TRUE if the property is visible; otherwise, FALSE. |
This schema rowset is not sorted.
The MDSCHEMA_PROPERTIES rowset can be restricted on the columns listed in the following table.
Column name | Type indicator | Restriction State |
|---|---|---|
CATALOG_NAME | DBTYPE_WSTR | Mandatory |
SCHEMA_NAME | DBTYPE_WSTR | Optional |
CUBE_NAME | DBTYPE_WSTR | Optional |
DIMENSION_UNIQUE_NAME | DBTYPE_WSTR | Optional |
HIERARCHY_UNIQUE_NAME | DBTYPE_WSTR | Optional |
LEVEL_UNIQUE_NAME | DBTYPE_WSTR | Optional |
MEMBER_UNIQUE_NAME | DBTYPE_WSTR | Optional |
PROPERTY_NAME | DBTYPE_WSTR | Optional |
PROPERTY_TYPE | DBTYPE_I2 | Optional |
PROPERTY_CONTENT_TYPE | DBTYPE_I2 | (Optional) A default restriction is in place on MDPROP_MEMBER OR MDPROP_CELL. |
PROPERTY_ORIGIN | DBTYPE_UI2 | (Optional) A default restriction is in place on MD_USER_DEFINED OR MD_SYSTEM_ENABLED |
CUBE_SOURCE | DBTYPE_UI2 | (Optional) A bitmap with one of the following valid values:
Default restriction is a value of 1. |
PROPERTY_VISIBILITY | DBTYPE_UI2 | (Optional) A bitmap with one of the following valid values:
Default restriction is a value of 1. |
