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).

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	Expression 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	MDX 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	Context 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	MDXValue The MDXValue object provides implicit conversion and casting among the following types: Hierarchy Level Member Tuple Set Scalar, or value types

See Also

Concepts

ADOMD.NET Server Programming

Help and Information

Getting SQL Server 2005 Assistance