Hello,
I'm trying to update security cube for MY_DIM with the code below but I get the error : Cell type is consolidated.
Prolog ligne de procédure(32): Le type de la cellule est Consolidation
Prolog ligne de procédure(32): erreur répétée 875 fois
There is more than 875 consolidated cells ( I get 3723 lines when using ElementType @='C' ) so I'm a little bit confuse.
Any though ?
Many thanks
Here the code (in Prolog Tab, same behaviour in Epilog) :
vDim1='MY_DIM';
vDim2='}Groups';
vHierarchy=HierarchyName;
vCube='}ElementSecurity_MY_DIM';
NbElt=ElementCount( vDim1,vHierarchy);
NbEltG=DIMSIZ(vDim2);
i=1;
while(i<=NbElt);
vElt=ElementName(vDim1,vHierarchy,i);
j=1;
IF(ElementLevel(vDim1,vHierarchy,vElt)<>0);
while(j<=NbEltG);
vGroup=DIMNM(vDim2,j);
IF(vGroup @<>'abc' % vGroup @<>'def');
IF(HierarchyElementExists(vDim1,vHierarchy,vElt)=1);
If(CellIsUpdateable(vCube,'MY_DIM:'|vHierarchy|':'|vElt,vGroup)=1);
CellPutS('WRITE',vCube,'MY_DIM:'|vHierarchy|':'|vElt,vGroup);
#
# IF(ElementType('MY_DIM', vHierarchy, vElt)@='C');
# asciioutput(OUTPUT_FILE, vCube, vHierarchy, vElt, vGroup);
# ENDIF;
#
ENDIF;
j=j+1;
ENDIF;
ENDIF;
END;
ENDIF;
i=i+1;
END;
------------------------------
Vivien
------------------------------
#PlanningAnalyticswithWatson