TM1 Forum

Hi ,

I have a customer dimension with customers from US, Germany and Asia . The Us customers might swap over the hierachy and other two customers are loaded in run time .


In the first process I am unwinding all the elements and adding only us elements and Germany and Asia parent nodes .

All -Customers -> America
Germany
Asia

Under America all customers are updated and then while cube load other two customers are added under germany and asia .

Now on the next day unwinding does all the data and I wanted only the customers under America to unwind .


Below is my code to unwind :

DIMENSIONSORTORDER(vDim,'','','ByHierarchy','ASCENDING');

vMax = DIMSIZ(vDim);
vCount = 1;

WHILE (vCount <= vMax);
vElem = DIMNM(vDim, vCount);

vMaxParents = ELPARN(vDim, vElem);
WHILE (vMaxParents>0);

vParent = ELPAR(vDim, vElem, vMaxParents);
DimensionElementComponentDelete(vDim, vParent, vElem);
vMaxParents = vMaxParents - 1;
END;

vCount = vCount + 1;
END;



Is there a way to ignore all the elements under Asia and germany

Thanks

Why not use a subset as the basis for your unwinding with only the elements you want to unwind otherwise use ELISANC to check if an element is part of the rollups to skip?