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();
}
}
