DefaultMember (Dimension 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 DefaultMember property of the Dimension interface defines the default member of the dimension.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
String
Access
Access depends on the value of the ClassType property of the object.
Class type |
Access |
|---|---|
clsDatabaseDimension |
R/W |
clsCubeDimension |
R |
clsPartitionDimension |
R |
clsAggregationDimension |
R |
Notes
DefaultMember is used to evaluate Multidimensional Expressions (MDX) expressions in which no context for the dimension is available. This property contains an MDX expression that evaluates to a single member of the dimension to which the property belongs. If blank, the Analysis server uses one of the members on the topmost level of the dimension as the default member. For example, if you define Redmond as the default member of the Geography dimension, tuples such as (Sales, 1997) can be evaluated as (Sales, 1997, Redmond).
Exemple
The following code example sets the default member to Food for the Product dimension in the FoodMart 2000 database:
' Assume the existence of a database dimension named dsoDim.
dsoDim.DefaultMember = "Food"