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
Unwinding specific elements in GLobal Customer diension
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
- gtonkin
- MVP
- Posts: 1192
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Unwinding specific elements in GLobal Customer diension
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?