Play Mate Of Apes Streaming Free

Make a cube process dynamically ... A New Blogger in

Hello everyone!
Many of you may have hoped one day to perform a Process Analysis Services cube dynamically in an application. The namespace
DSO (Decision Support Objects) allows you to connect to Analysis Services server offers a simple and intuitive API based on COM components through Interop.
The namespace is available in the DSO framework 1.1 and can drive Analysis Services 2000 and 2005. The namespace
AMO (Analysis Management Object - Microsoft.AnalysisServices) replaced advantageously the namespace in the DSO framework 2.0.

Here are some basics for using DSO ...

The following code allows for a connection to the local server:
DSO.ServerClass dsoServer DSO.ServerClass = new ();
dsoServer.Connect ("localhost");

Then it is possible to position based on "Test" as follows:
DSO.Database dsoDB dsoServer.MDStores.Item = ("Test");

Finally, a cube or dimension can be given identified as follows:
DSO.Cube dsoCube dsoDB.MDStores.Item = ("Moncube");
DSO.Dimension dsoDim dsoDB.Dimensions.Item = ("MaDimension");

The process of the cube or one dimension is then very easily done:
dsoDim.Process (DSO.ProcessTypes.processFull)
dsoCube.Process (DSO.ProcessTypes.processFull)

If you change the cube dynamically (adding or deleting dimension modification of the terms of jointness, ...), it is necessary to update the cube before performing the process:
dsoCube.Update ();

Think of you always Logout - typically in the finally your try-catch blocks:
dsoServer.Disconnect ();

... And for the use of AMO ...

The following code allows for a connection to the local server:
Microsoft.AnalysisServices.Server amoServer Microsoft.AnalysisServices.Server = new ();
amoServer.Connect ("Data Source = localhost");

The Process the cube is equally simple:
amoServer.Databases ["Test"]. Cubes ["Moncube"]. Process ();

Note the names of the collections much cleaner (instead of Databases MDStores).

A simple steering for government applications interactive! But be careful not to forget that a process cube can be a costly action, and it is often not very fashionable to make the data unavailable during the day ;-)