Security GUI

Suggest and discuss enhancements for TM1
Post Reply
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Security GUI

Post by Steve Vincent »

the security GUI is usless. In 9.0 it was never that fast but in 9.5 its even worse. it took 45 MINUTES to change element security with about 2000 elements and 25 groups via the GUI. the TI code below does this in less than 5 SECONDS.


gMax = DIMSIZ ( '}Groups' );
gn = 1;

Code: Select all

WHILE ( gn <= gMax );
    group = DIMNM ( '}Groups' , gn );
    eMax = DIMSIZ ( dim );
    en = 1;

    WHILE ( en <= eMax );
        ElName = DIMNM ( dim , en );
        ElementSecurityPut ( 'NONE' , Dim, ElName, Group );
        en = en + 1;
    END;

    gn = gn + 1;
END;
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Post Reply