HideMemberIf (Level Interface)
The HideMemberIf property of the Level interface indicates whether and when a level member should be hidden from client applications.
Applies To
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 earlier versions of Microsoft® SQL Server™ 2000 Analysis 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 countries level. Some countries, however, do not have states or provinces. In such cases a placeholder occupies the position.