Add New Skills!

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

Wednesday, March 23, 2011

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

















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