Properties, MDStore Interface
[!REMARQUE]
Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité.
The MDStore interface supports the following properties.
Property |
Description |
---|---|
Contains the prefix that associates the MDStore object with an aggregation in the store. |
|
Indicates whether drillthrough is allowed on the cube. |
|
The analyzer object for the store. |
|
Returns an enumeration constant identifying the specific object type. |
|
The name of the default measure for the object. |
|
The description of the store. |
|
The columns that are included in a drillthrough query. |
|
The statement restricting rows that are returned by a drillthrough query. |
|
An SQL FROM clause with the names of the tables used in drillthrough queries. |
|
An SQL JOIN clause with the names of the tables used in drillthrough queries. |
|
The estimated number of rows in the store. |
|
Estimated size of all rows, in bytes, in the store. |
|
A comma-separated list of the tables from which the store data is obtained. |
|
Indicates whether the store is the default store. |
|
Indicates whether the MDStore object is writable. |
|
Indicates whether the object is temporary. |
|
Indicates whether the store object is valid. |
|
Indicates whether a cube is visible to clients. |
|
A list of join conditions separated by AND. |
|
The date and time a store was last processed. |
|
A user-defined date. This property is not used by Microsoft® SQL Server™ 2005 Analysis Services. |
|
The name of the store. |
|
Returns an enumeration constant that identifies the type of OLAP mode of the store. |
|
Returns a reference to the parent MDStore object. |
|
Sets the number of allowable errors that can occur before processing will be stopped. |
|
The UNC path to a file for logging dimension key errors encountered during processing. |
|
Indicates whether the Analysis server creates indexes and aggregations during or after processing. |
|
The name of the remote server where the data for the MDStore object is stored. |
|
Returns a reference to the DSO.Server object. |
|
The name of the source table for the store. |
|
The alias of the source table for the MDStore object. |
|
The SQL expression that specifies the source table records to include in the store. |
|
Returns an enumeration constant indicating the difference between the MDStore object that is referenced by the DSO client application and the corresponding MDStore object on the Analysis server. |
|
Returns an enumeration constant that identifies the subclass type of the object. |
Property Cross-Reference
The following table shows whether the property is read/write (R/W), read-only (R), or not applicable (n/a) for different objects.
Property |
Database |
Cube |
Partition |
Aggregation |
---|---|---|---|---|
R |
R/W |
R/W |
R |
|
n/a |
R/W |
R |
n/a |
|
n/a |
R* |
R |
n/a |
|
R |
R |
R |
R |
|
n/a |
R/W |
R |
n/a |
|
R/W |
R/W |
R/W |
R/W |
|
n/a |
R/W |
R/W |
n/a |
|
n/a |
R/W |
R/W |
n/a |
|
n/a |
R/W |
R/W |
n/a |
|
n/a |
R/W |
R/W |
n/a |
|
n/a |
R/W** |
R/W |
R/W |
|
R |
R |
R |
R |
|
n/a |
R/W* |
R/W |
R/W |
|
n/a |
n/a |
R |
R/W |
|
R |
R |
R/W |
n/a |
|
n/a |
R |
R |
R |
|
R |
R |
R |
R |
|
n/a |
R/W |
n/a |
n/a |
|
n/a |
R/W* |
R/W |
R/W |
|
R |
R |
R |
R |
|
R/W |
R/W |
R/W |
R |
|
R/W (R after the object has been named) |
R/W (R after the object has been named) |
R/W (R after the object has been named) |
R/W (R after the object has been named) |
|
R/W |
R/W* |
R/W |
R/W |
|
R |
R |
R |
R |
|
n/a |
n/a |
R/W |
n/a |
|
R |
R |
R |
R |
|
n/a |
R/W* |
R/W |
R/W |
|
n/a |
R/W |
R/W |
n/a |
|
n/a |
R/W* |
R/W |
n/a |
|
R |
R |
R |
n/a |
|
R |
R |
R |
R |
* This property is not applicable (n/a) for virtual cubes (that is, those of SubClassType sbclsVirtual).
** This property is read-only (R) for virtual cubes (that is, those of SubClassType sbclsVirtual).