private static void GetBWCube(R3Connection con, string name) { using (con) { con.Open(false); //0,0D_NW_CHANN,Distribution Channel, C,255,0 //1,0D_NW_CNTRY,Country,C,255,0 //2,0D_NW_CODE,Company code, C,255,0 //3,0D_NW_DIV,Division,C,255,0 //4,0D_NW_PAYER,Payer,C,255,0 //5,0D_NW_PLANT,Plant,C,255,0 //6,0D_NW_PROD,Product,C,255,0 //7,0D_NW_REGIO,Region,C,255,0 //8,0D_NW_SGRP,Sales Group, C,255,0 //9,0D_NW_SHIP,Ship - to Party,C,255,0 //10, 0D_NW_SOLD,Sold - to Party,C,255,0 //11, 0D_NW_SORG,Sales Organization, C,255,0 //12, 0CALYEAR,Calendar Year, C,255,0 //13, 0MEASURES0000000000000009_0D9NW9NETV000000000000010,Net Value stat curr, P,16,0 //14, 0MEASURES0000000000000009_0D9NW9OORV000000000000010,Open order stat curr, P,16,0 BWCube query = con.CreateBWCube(name); query.Dimensions["0D_NW_CHANN"].SelectForFlatMDX = true; query.Dimensions["0D_NW_CNTRY"].SelectForFlatMDX = true; query.Dimensions["0D_NW_CODE"].SelectForFlatMDX = true; query.Dimensions["0D_NW_DIV"].SelectForFlatMDX = true; query.Dimensions["0D_NW_PAYER"].SelectForFlatMDX = true; query.Dimensions["0D_NW_PLANT"].SelectForFlatMDX = true; query.Measures[0].SelectForFlatMDX = true; query.Measures[1].SelectForFlatMDX = true; query.Measures[2].SelectForFlatMDX = true; query.Measures[3].SelectForFlatMDX = true; //query.Variables["MAT01"].SingleRange.LowValue = this.txtMatNr.Text; DataTable table = query.Execute(); Console.Read(); } }