/ Published in: C#
Expand |
Embed | Plain Text
String serverName = "localhost"; String databaseName = "PM Cube Solution 15 01 2008"; String databaseID = databaseName; String cubeID = "Beispiel Daten"; AdomdConnection cn = new AdomdConnection("Provider=MSOLAP;Data Source=" + serverName + ";Initial Catalog=" + databaseName); cn.Open(); AdomdCommand cmd; cmd = cn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "<Batch xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\"><Parallel><Process> <Object>" + "<DatabaseID>" + databaseID + "</DatabaseID>" + "<CubeID>" + cubeID + "</CubeID> " + "</Object><Type>ProcessFull</Type><WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch>"; try { Console.WriteLine("Executing Command..."); cmd.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { cn.Close(); Console.WriteLine("Finished"); }
You need to login to post a comment.
