Saturday, July 24, 2010

Process the Cube using Batch method

There are many ways to process an Cube.
a. Batch Processing
b. parallel processing
c. Push-mode processing
d. Lazy processing of indexes and aggregations

By Processing the cube the Analysis server reads data from the relational data source and populates the cubes, dimensions, mining models, etc. so that the cube is sync the latest data in the relational data source.

Following is the sample for processing the cube using Batch Process. Batch process is the convenient one since we can send multiple commands to the server using single xmla file.

AdomdConnection objadomdConn = new AdomdConnection();
objadomdConn = OpenAnalysisServiceConnection();
if (objadomdConn!=null )
{

String ExecuteProcessQuery ="

Cube DB Name Dimension Id
ProcessFull


Cube DB Name Cube Id
ProcessFull

";
AdomdCommand Execcmd;
Execcmd = objadomdConn.CreateCommand();
Execcmd.CommandType = CommandType.StoredProcedure;
Execcmd.CommandText = ExecuteProcessQuery;
Execcmd.ExecuteNonQuery();

http://msdn.microsoft.com/en-us/library/ms345142(SQL.90).aspx

No comments: