Skip to Content
0
Mar 06, 2015 at 08:23 AM

Mass deletion of analysis authorizations in BW 7.0

283 Views

Hello all,

since there is no mass maintenance tool in BW 7.0 (especially for deleting AAs), is it safe to write a small ABAP program that deletes the contents from the related tables, e.g.:

DELETE * FROM RSECVAL WHERE TCTAUTH <> '0BI_ALL';

DELETE * FROM RSECHIE WHERE TCTAUTH <> '0BI_ALL';

DELETE * FROM RSECTXT WHERE TCTAUTH <> '0BI_ALL';


Did I miss something? Any other relations?


Thanks in advance!