[OLAP] Process SSAS Cube using C# (c#코드로 큐브처리)

1. String serverName = "localhost";
2. String databaseName = "PM Cube Solution 15 01 2008";
3. String databaseID = databaseName;
4. String cubeID = "Beispiel Daten";
5. AdomdConnection cn = new AdomdConnection("Provider=MSOLAP;Data Source=" + serverName + ";Initial Catalog=" + databaseName);
6. cn.Open();
7. AdomdCommand cmd;
8. cmd = cn.CreateCommand();
9. cmd.CommandType = CommandType.Text;
10.  
11. cmd.CommandText = "<Batch xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\"><Parallel><Process> <Object>" +
12. "<DatabaseID>" + databaseID + "</DatabaseID>" +
13. "<CubeID>" + cubeID + "</CubeID> " +
14. "</Object><Type>ProcessFull</Type><WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch>";
15. try
16. {
17. Console.WriteLine("Executing Command...");
18. cmd.ExecuteNonQuery();
19. }
20. catch (Exception ex)
21. {
22. Console.WriteLine(ex.Message);
23. }
24. finally
25. {
26. cn.Close();
27. Console.WriteLine("Finished");
28. }
29. 
    

look at this sample:
http://snipplr.com/view/11385/process-ssas-cube/

Accepted Solution250EXCELLENT

carsRST2010-05-24 at 05:54:44ID: 32832095

To open up connections to Analysis services, you'll use ADOMD.NET.
Info on opening the connection:
http://technet.microsoft.com/en-us/library/ms123468.aspx

Another example on processing a cube.  Not in C#, but concepts and calls the same.
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/567b6a76-9d45-4bd6-9fb6-ddd28c5c31b3/