Applies To: SQL Server 2016 Preview
Represents a named set for a given cube.
Assembly: Microsoft.AnalysisServices.AdomdClient (in Microsoft.AnalysisServices.AdomdClient.dll)
Gets the caption of the named set.
Gets the description of the.
Gets the fully qualified name of a display folder.
Gets the MDX set expression that defines the.
Gets the name of the.
Gets a CubeDef that contains the .
Gets a PropertyCollection that contains the properties associated with the .
Determines whether two instances of Object.Equals(Object).)are equal.(Overrides
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().)
(Inherited from Object.)
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.
Aencapsulates 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
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.