AMO學習-建立新的Partition

今天寫了一個非常簡單的Partition分割程式

 Server server = new Server();

 server.Connect(@"data source=localhost");

 Database db = server.Databases["RYOOLAP"];

 Cube cubes = db.Cubes["Cube"];

 MeasureGroup mg = cubes.MeasureGroups["FactALL"];

 Partition pt = mg.Partitions.Add("Partition9901");

 pt.Source = new QueryBinding("CRIM", "SELECT * FROM [dbo].[FactALL] WHERE  All_SSYM = '9901' ");

 pt.Update();

 pt.Process();