The below nugget has been created from the following Microsoft webcast
XMLA: XML for Analysis is the native scripting language that Analysis Services understands. It is the data definition language for dimensions and measures. These scripts are run on the server when the cube is built.
There is an Object Model API (Analysis Management Objects - AMO) on top of XML to run the data definitions.
.NET Programming against Analysis Services
XMLA: XML for Analysis is the native scripting language that Analysis Services understands. It is the data definition language for dimensions and measures. These scripts are run on the server when the cube is built.
There is an Object Model API (Analysis Management Objects - AMO) on top of XML to run the data definitions.
.NET Programming against Analysis Services
- Open ADOMD connection object
- Create data adapter, data table
- Use command object and pass the MDX query
- Fill the data adapter
APIs
ADOMD.net (data+metadata) and AMO(metadata+cube administration)
