| title | ADOMD.NET Server Object Architecture | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/06/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | analysis-services | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| ms.assetid | bdc81de9-b390-4654-b62a-cd6c0c9ca10d | ||
| author | minewiskan | ||
| ms.author | owend | ||
| manager | craigg |
The ADOMD.NET server objects are helper objects that can be used to create user defined functions (UDFs) or stored procedures in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion].
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 | xref:Microsoft.AnalysisServices.AdomdServer.Expression The xref: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 | xref:Microsoft.AnalysisServices.AdomdServer.MDX The xref:Microsoft.AnalysisServices.AdomdServer.MDX object is convenient for calling predefined MDX functions without using the xref:Microsoft.AnalysisServices.AdomdServer.Expression object. Additional functions for the xref:Microsoft.AnalysisServices.AdomdServer.MDX object should be available in future releases. |
| Represent the current execution context for the UDF | xref:Microsoft.AnalysisServices.AdomdServer.Context The xref:Microsoft.AnalysisServices.AdomdServer.Context object exposes information such as the current cube or mining model and various metadata collections. One key use of the xref:Microsoft.AnalysisServices.AdomdServer.Context object is the xref:Microsoft.AnalysisServices.AdomdServer.Hierarchy.CurrentMember%2A property of the xref: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 | xref:Microsoft.AnalysisServices.AdomdServer.SetBuilder, xref:Microsoft.AnalysisServices.AdomdServer.TupleBuilder The xref:Microsoft.AnalysisServices.AdomdServer.SetBuilder provides a way to create immutable sets, while the xref: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 | xref:Microsoft.AnalysisServices.AdomdServer.MDXValue The xref:Microsoft.AnalysisServices.AdomdServer.MDXValue object provides implicit conversion and casting among the following types: - xref:Microsoft.AnalysisServices.AdomdServer.Hierarchy - xref:Microsoft.AnalysisServices.AdomdServer.Level - xref:Microsoft.AnalysisServices.AdomdServer.Member - xref:Microsoft.AnalysisServices.AdomdServer.Tuple - xref:Microsoft.AnalysisServices.AdomdServer.Set - Scalar, or value types |