Hi all,
quick question about using RoundDecimal in App Engine jobs (V11) - we are extracting out reporting currency from a cube, and there are some infitesimal numbers in the cube because of some foreign currency rules. I want to export the data out - but do a round to 3 decimal places on the cube cell value. This is my code for the olap data area -
OLAPDataArea SourceData4 = OLAPCreateDataArea(connection, CopyCube,
OlapDataAreaIncludeB | OlapDataAreaIncludeC | OlapDataAreaSuppressNull , OlapDataAreaOperatorNotEqual, 0.0, OlapDataAreaOperatorNone, 0.0,
olapactp4, SourceHotelList, OlapDataAreaBCells, OlapDataAreaBCells, OlapDataAreaBCells, OlapDataAreaBCells, SourceContractTypeList,
OlapDataAreaBCells,OlapDataAreaBCells, RateMember, RatesetMember, olapactv4, MeasureMember);
/* cycle through the data area and copy to SQL table*/
WriteLine("Create date settings");
//DateTime now = CreateDateTime(); string sdate = GetDateTimeAsString(now,"ddMMyyyy", "en"); string sdatef = GetDateTimeAsString(now,"yyyyMMdd", "en");
WriteLine("loop started");
foreach(OLAPCell cell in SourceData4)
{ string sversion= OLAPCellGetElement(cell, "VERSION"); string shotel = OLAPCellGetElement(cell, "HOTEL");
string speriod = OLAPCellGetElement(cell, "PERIOD"); string sbrand = OLAPCellGetElement(cell, "BRAND");
string scontracttype = OLAPCellGetElement(cell, "CONTRACTTYPE"); string sdepartment = OLAPCellGetElement(cell, "DEPARTMENT");
string smarketsegment = OLAPCellGetElement(cell, "MARKETSEGMENT"); string smealperiod = OLAPCellGetElement(cell, "MEALPERIOD");
string srate = OLAPCellGetElement(cell, "RATE"); string srateset = OLAPCellGetElement(cell, "RATESET");
string scurrency = OLAPCellGetElement(cell, "CURRENCY"); string saccounts = OLAPCellGetElement(cell, "ACCOUNTS");
string smeasures = OLAPCellGetElement(cell, "MEASURES"); double value = cell;
double RoundDecimal(double value,3);
I am wanting to use the roundecimal command on the double value = cell
