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 |