Represents a named set for a given cube.
Assembly: Microsoft.AnalysisServices.AdomdClient (in Microsoft.AnalysisServices.AdomdClient.dll)
Thetype exposes the following members.
|Caption||Gets the caption of the named set.|
|Description||Gets the description of the .|
|DisplayFolder||Gets the fully qualified name of a display folder.|
|Expression||Gets the MDX set expression that defines the .|
|Name||Gets the name of the .|
|ParentCube||Gets a CubeDef that contains the .|
|Properties||Gets a PropertyCollection that contains the properties associated with the .|
|Equals||Determines whether two instances of are equal. (Overrides Object.Equals(Object).)|
|GetHashCode||Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures such as hash tables. (Overrides Object.GetHashCode().)|
|GetType||(Inherited from Object.)|
|ToString||Returns a String that represents the current object. (Overrides Object.ToString().)|
A named set is a persisted set expression, which is associated with an alias and defined as part of the structure of a cube. In Multidimensional Expressions (MDX), a set expression can be a lengthy and complex declaration. A named set makes it easier to manage a set expression that is used regularly in MDX or XML for Analysis queries that involve the cube and provides a way of maintaining the set expression independently of the queries that use it.
A encapsulates the alias and set expression of a named set, so that the metadata of the named set can be examined and incorporated into queries.
Public Sub ListNamedSets(ByRef CubeToCheck As CubeDef) ' Check the parameter before performing actions on it. If CubeToCheck Is Nothing Then Throw New System.ArgumentNullException("CubeToCheck") Else ' Iterate through the NamedSets collection of the ' CubeDef object. Try Dim nsetToCheck As NamedSet Debug.WriteLine("Found " & CubeToCheck.NamedSets.Count & _ " named set(s) in cube:") For Each nsetToCheck In CubeToCheck.NamedSets Debug.WriteLine("Named Set: " & nsetToCheck.Name) Debug.WriteLine(" Description: " & _ nsetToCheck.Description) Debug.WriteLine(" Expression: " & _ nsetToCheck.Expression) 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