ADOMD.NET Server Object Architecture

The ADOMD.NET server objects are helper objects that can be used to create user defined functions (UDFs) or stored procedures in Microsoft SQL Server Analysis Services.

Note

To use the Microsoft.AnalysisServices.AdomdServer namespace (and these objects), a reference to the msmgdsrv.dll must be added to UDF project or stored procedure.

ADOMD.NET Object Model

Interaction with the ADOMD.NET object hierarchy typically starts with one or more of the objects in the topmost layer, as described in the following table.

To	Use this object
Evaluate Multidimensional Expressions (MDX) expressions	Microsoft.AnalysisServices.AdomdServer.Expression The Microsoft.AnalysisServices.AdomdServer.Expression object provides a way to run an MDX expression and evaluate that expression under a specified tuple.
Provide support for executing MDX functions without constructing the full MDX statement	Microsoft.AnalysisServices.AdomdServer.MDX The Microsoft.AnalysisServices.AdomdServer.MDX object is convenient for calling predefined MDX functions without using the Microsoft.AnalysisServices.AdomdServer.Expression object. Additional functions for the Microsoft.AnalysisServices.AdomdServer.MDX object should be available in future releases.
Represent the current execution context for the UDF	Microsoft.AnalysisServices.AdomdServer.Context The Microsoft.AnalysisServices.AdomdServer.Context object exposes information such as the current cube or mining model and various metadata collections. One key use of the Microsoft.AnalysisServices.AdomdServer.Context object is the Microsoft.AnalysisServices.AdomdServer.Hierarchy.CurrentMember property of the Microsoft.AnalysisServices.AdomdServer.Hierarchy object. This key usage enables the author of the UDF or stored procedure to make decisions based on what member from a certain dimension the query is on.
Create sets and tuples	Microsoft.AnalysisServices.AdomdServer.SetBuilder, Microsoft.AnalysisServices.AdomdServer.TupleBuilder The Microsoft.AnalysisServices.AdomdServer.SetBuilder provides a way to create immutable sets, while the Microsoft.AnalysisServices.AdomdServer.TupleBuilder provides a way to create immutable tuples.
Support implicit conversion and casting among the six basic types of the MDX language	Microsoft.AnalysisServices.AdomdServer.MDXValue The Microsoft.AnalysisServices.AdomdServer.MDXValue object provides implicit conversion and casting among the following types: Microsoft.AnalysisServices.AdomdServer.Hierarchy Microsoft.AnalysisServices.AdomdServer.Level Microsoft.AnalysisServices.AdomdServer.Member Microsoft.AnalysisServices.AdomdServer.Tuple Microsoft.AnalysisServices.AdomdServer.Set Scalar, or value types