Assembly: Microsoft.AnalysisServices.AdomdClient (in microsoft.analysisservices.adomdclient.dll)
In the axis specification for a given axis in a multidimensional query, the set expression selects tuples with which to populate the axis. The cellset returns basic information about each member in each tuple, such as member name, parent level, and number of children. Members often have additional properties associated with them, referred to as member properties, which are available for all members at a given level.
The MemberProperty represents a single member property for a Member.
The following subroutine, given a Member, iterates through the MemberProperties collection and displays information for each MemberProperty in the collection:
Public Sub ListMemberProperties(ByRef MemberToCheck As Member) ' Check the parameter before performing actions on it. If MemberToCheck Is Nothing Then Throw New System.ArgumentNullException("MemberToCheck") Else ' Iterate through the MemberProperties collection of the ' Member object. Try Dim propToCheck As MemberProperty Debug.WriteLine("Found " & _ MemberToCheck.MemberProperties.Count & _ " member properties in member:") For Each propToCheck In MemberToCheck.MemberProperties Debug.WriteLine("Member Property: " & propToCheck.Name) Debug.WriteLine(" Value: " & _ propToCheck.Value) Next Catch ex As AdomdConnectionException ' The connection could not be opened or was disconnected. ' This error can occur at any time, if the provider is ' disconnected from the server. Debug.WriteLine(ex) Throw ex Catch ex As AdomdErrorResponseException ' A response is received from a provider which indicates an error. Debug.WriteLine(ex) Throw ex Catch ex As AdomdUnknownResponseException ' A response has been returned from the provider that ' was not understood. Debug.WriteLine(ex) Throw ex Catch ex As AdomdCacheExpiredException ' A cached version of an ADOMD.NET object is no longer valid. ' This error is typically raised when reviewing metadata. Debug.WriteLine(ex) Throw ex Catch ex As AdomdException ' Any other error raised by ADOMD.NET. Debug.WriteLine(ex) Throw ex Catch ex As Exception ' Any other error. Debug.WriteLine(ex) Throw ex End Try End If End Sub