Just another Blog

My Technical, Professional and at times Personal Blog

Showing posts with label BI for .NET. Show all posts

BI for .NET framework developer

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

  1. Open ADOMD connection object
  2. Create data adapter, data table
  3. Use command object and pass the MDX query
  4. Fill the data adapter

ADOMD.net (data+metadata) and AMO(metadata+cube administration)

Google+ Followers