ADOMD.NET Server Object Architecture

New: 5 December 2005

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 2005 Analysis Services (SSAS).

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
Shows the object relationships in ADOMD.NET Server

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


The 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


The MDX object is convenient for calling predefined MDX functions without using the Expression object. Additional functions for the MDX object should be available in future releases.

Represent the current execution context for the UDF


The Context object exposes information such as the current cube or mining model and various metadata collections. One key use of the Context object is the CurrentMember property of the 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

SetBuilder, TupleBuilder

The SetBuilder provides a way to create immutable sets, while the TupleBuilder provides a way to create immutable tuples.

Support implicit conversion and casting among the six basic types of the MDX language


The MDXValue object provides implicit conversion and casting among the following types:

Community Additions