Properties, MDStore Interface
[!NOTA] Esta característica se quitará en la versión siguiente de Microsoft SQL Server. No utilice esta característica en nuevos trabajos de desarrollo y modifique lo antes posible las aplicaciones que actualmente la utilizan.
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).