Planning Analytics with Watson

Expand all | Collapse all

Cell type is consolidated

Jump to Best Answer
  • 1.  Cell type is consolidated

    Posted 12 days ago
    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
    ------------------------------


  • 2.  RE: Cell type is consolidated
    Best Answer

    Posted 12 days ago
    Hi Vivien,

    I seem to remember getting a "Cell is Consolidated" error when a TI would try to write to the Admin, DataAdmin or SecurityAdmin groups. I might be wrong but it's definitely rattling around in the back of my brain somewhere saying that was a thing.
    So you could try and add an additional check for your If statement to check that the group is not one of the auto generated admin groups.


    Thanks,
    Declan

    ------------------------------
    Declan Rodger
    Technical Director
    Spitfire Analytics
    ------------------------------



  • 3.  RE: Cell type is consolidated

    Posted 11 days ago
    Hi Declan,

    as usual you have the correct answer. Some of groups were Admin, DataAdmin or SecurityAdmin

    many thanks
    Vivien

    ------------------------------
    Vivien
    ------------------------------