Unwinding specific elements in GLobal Customer diension

Post Reply
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

Unwinding specific elements in GLobal Customer diension

Post by Analytics123 »

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
User avatar
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

Post by gtonkin »

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?
Post Reply