SSAS Series--"05" Multidimensional data (programming architecture)

Original: SSAS Series-"05" Multidimensional data (programming architecture)

1. What is AMO?

Translation: Amo is a complete collection of management classes in SSAS, which we can find in "\100\sdk\assemblies\analysisservices.dll" under the Microsoft.analysisservices namespace. With Amo we can delete and modify cube, dimensions, Mining structure,analysis Service Database,amo not be able to retrieve data, we must also use Adomd.net to retrieve the data.

2. What is AMO's architecture?

Know:

Diagram of AMO architecture

There is no need to delve into this, the use of natural understanding. AMO can implement an automated and configurable hypervisor to service SSAS. Learn about early versions of AMO decision Support Objects (DSO), the highest version is 9.0, phasing out, for beginners I, there is no compatibility problem, omitted.

3. What is ASSL?

The analysis Services Scripting Language (ASSL) DDL is actually an XML file that defines the schema of the objects, how to bind the data source and object, define the security of the object, manipulate the object, and describe the object.

4. What is XMLA?

The XML for analysis is actually a specification, SOAP-based XML protocol that must be respected by both AMO and adomd.net. Do not look at the concept in detail, after use natural understanding.

5, ADOMD. NET concept?

The concept itself is similar to ADO, except that he is used to deal with multidimensional data, how to retrieving Metadata, retrieving data, and change the structure of the analytical data, which needs to be understood as an experienced person once.

Figure ADOMD. NET structure to understand

SSAS Series--"05" Multidimensional data (programming architecture)