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.
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