HideMemberIf (Level Interface)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The HideMemberIf property of the Level interface indicates whether and when a level member should be hidden from client applications.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
Data Type
Access
Access depends on the value of the ClassType property of the object. This property does not apply to levels whose SubClassType is sbclsParentChild or sbclsMining.
| Class type | Access |
|---|---|
clsDatabaseLevel |
R/W* |
clsCubeLevel |
R |
clsPartitionLevel |
R |
clsAggregationLevel |
R |
* Always read-only and set to hideNever for levels of virtual dimensions created in Microsoft® SQL Server™ 7.0 OLAP Services.
Remarks
Hidden members represent empty positions in a ragged hierarchy. The members are hidden to function as placeholders for a branch of a hierarchy that contains no real members at that level. For example, a geography dimension may have cities at its lowest level. Members on this level roll up into a state/province level, which, in turn, rolls up into a country/region level. Some countries and regions, however, do not have states or provinces. In such cases a placeholder occupies the position.