OLAPSetDataAreaValue "Index was out of range. Must be non-negative and less than the size of the col

unknown

Trying to work with OLAPSetDataAreaValue in the following code snipet:

OLAPConnection olapCon = OLAPCreatePooledNamedConnection("FSM");
OLAPElement entpar = OLAPGetDimensionElement(olapCon, "GLTOT_FinanceDImension1", "TOP_NODE");
OLAPElementList EntityList2 = CreateOLAPElementList();
OLAPElementList EntityList = CreateOLAPElementList();

OLAPElementListAddElement(EntityList, entpar);
EntityList2 = OLAPGetChildElementList(olapCon, "GLTOT_FinanceDImension1", "TOP_NODE", false);

foreach (OLAPElement el in EntityList2)
    {
        NotifyDebug("Adding Element: "+ el);
        OLAPElementListAddElement(EntityList, el);
    }

OLAPDataArea cubeVals = OLAPCreateDataArea(olapCon, "#GLTOT_FinanceDImension1", OlapDataAreaNone, OlapDataAreaOperatorNone, 0.0, OlapDataAreaOperatorNone, 0.0 ,EntityList, "20220510", "BIFSM_Custom_Data_Role");
OLAPSetDataAreaValue(cubeVals, 0);
OLAPDisconnectPooledConnection(olapCon);
return;

The error returned is triggered at OLAPSetDataAreaValue(cubeVals, 0).  I assume the "index" here is referring to the value argument, which in this case is 0.   Any one have any insights on whats going wrong here? I have a feeling its related to how Im building the OLAPDataArea but havent been able to find much info on this it. 

Thanks,

Matt

unknown

Hi,

have you tried using "OlapDataAreaIncludeB" instead of "OlapDataAreaNone" as a filter for creating the data area?

I got the same error with OLAPCopyDataArea when I tried to write to C elements, setting the filter to n elements worked for me.

Best regards
Pascal