public void Main()

{

// TODO: Add your code here

Dts.TaskResult = (int)ScriptResults.Success;

//User::varolapconnstr,User::varolapdbname

var olapconnstr = Dts.Variables["User::varolapconnstr"].Value.ToString();

var olapdbname = Dts.Variables["User::varolapdbname"].Value.ToString();

var olapcubename = Dts.Variables["User::varcubename"].Value.ToString();

//Connect db then process

Server _server = new Server();

try

{

_server.Connect(olapconnstr);

if (_server.Connected)

{

Database _db = _server.Databases.FindByName(olapdbname);

//Process dimensions

if (_db != null)

{

foreach (Dimension _dim in _db.Dimensions)

{

_dim.Process(ProcessType.ProcessFull);

}

//Process cube

if (!string.IsNullOrEmpty(olapcubename))

{

Cube _cb = _db.Cubes.FindByName(olapcubename);

if (_cb != null)

_cb.Process(ProcessType.ProcessFull);

}

else

{

//process every cube

foreach (Cube _cb in _db.Cubes)

{

try

{

_cb.Process(ProcessType.ProcessFull);

}

catch (Exception ex)

{

Dts.Events.FireWarning(, "CUBE Refresh", ex.Message, "", );

}

}

}

}

}

}

catch (Exception ex)

{

Dts.Events.FireWarning(, "CUBE Refresh", ex.Message, "", );

}

finally

{

if(_server.Connected)

_server.Disconnect();

}

}