TM1 Forum

Hello ALL,

I am trying to clean cube data based on a dimension hierarchy for a specific roll up. Created one TI with coded embedded as :

vFunctionDimNm = 'Function';
nDimCount = DIMSIZ(vFunctionDimNm);
nElementCounter = 1 ;
WHILE ( nElementCounter < nDimCount + 1);
vElementNm = DIMNM(vFunctionDimNm, nElementCounter );
vValue = CellGetS('RDEXSL_Pln_Upd_CC_Select', ELPAR( vFunctionDimNm, vElementNm,1), 'Flag_CC_Selection');
nCheck = ELISANC(vFunctionDimNm, 'THDISC', vElementNm);
IF( nCheck = 1 & vValue@= '');
CellPutS('', 'RDEXSL_Pln_Upd_CC_Select', vElementNm, 'Flag_CC_Selection');
ELSE;
ItemSkip;
EndIf;
nElementCounter = nElementCounter+1 ;
END;
In attachment you can see the structure of cube and the goal i am trying to achieve but some how it is not working. Not sure where i am failing, so need your help.

Thanks,
Manoj

Hello,

Did you debug the code using AsciiOutput or TextOutput or LogOutput ?

Quickly looking at your code, I see an ELPAR which can sometimes be the cause of issues if one element can have multiple parents.
Just a thought, please debug your code and keep this in mind.

Good morning all, I do not understand this nElementCounter = 1 ;
WHILE ( nElementCounter < nDimCount + 1); The search is beginning from second level element as ndimcount+1 is 1+1=2

Where as in previous posts the logic is stated as nElementCounter = 1 ;
WHILE ( nElementCounter <= nDimCount ); can somebody please clear my doubt.

Either you loop while the counter is strictly smaller than the total plus 1,
either you loop until you hit (<=) the total (but not adding the plus 1).

The difference is in the <= or <

Does it matter..

The problem seems to be in logic, not in counter initialization and in loop. If i use code:

FunctionDimNm = 'Function';
nDimCount = DIMSIZ(vFunctionDimNm);
nElementCounter = 1 ;
WHILE ( nElementCounter < nDimCount + 1);
vElementNm = DIMNM(vFunctionDimNm, nElementCounter );
vValue = CellGetS('RDEXSL_Pln_Upd_CC_Select', ELPAR( vFunctionDimNm, vElementNm,1), 'Flag_CC_Selection');
IF(vValue@= '');
CellPutS('', 'RDEXSL_Pln_Upd_CC_Select', vElementNm, 'Flag_CC_Selection');
ELSE;
ItemSkip;
EndIf;
nElementCounter = nElementCounter+1 ;
END;

It works fine for all elements of dimension. But the requirement is to run it for specific parent. Any help would be appreciated.

You could insert an IF test in the loop, With the ELISANC function. That function allows to execute your code only on 1 part of a dimension.