Export cube values using XML

unknown

Hi,

I am trying to export some cube values by running this xml in an appEngine process:

There is a 'define dataarea' before but this is not relevant at the moment.

I want to export all values <> 0, but doing this with the attribute 'TreatZeroAsEmtpyCell' doesn't work.

Does anyone have experience with exporting cube values without null values?

Regards Pascal

Peter Mayall

I would suggest using the OLAP functions over the XML functions.

Refer to https://docs.infor.com/depm/2023.x/en-us/depmolh_cloud/default.html?helpcontent=application_engine_cloud/vuj1510174436991.html.

Sample code:

OLAPDataArea dataArea = OLAPCreateDataArea(olapConn, "Cube",
    OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNone, 0.00, OlapDataAreaOperatorNone, 0.0,
    version, OlapDataAreaAllCells, OlapDataAreaAllCells, OlapDataAreaAllCells);

foreach (OLAPCell cell in dataArea) {
    string dim02 = OLAPCellGetElement(cell, "Dim 02");
    string dim03 = OLAPCellGetElement(cell, "Dim 03");
    string dim04 = OLAPCellGetElement(cell, "Dim 04");
    double value = cell;
}