That will reclaim the obsolete space from the lobs. The documentation claims that it is not necessary for "secure file" lobs.
ALTER TABLE <schema>.AW$<awname> REBUILD FREEPOOLS
You will still find a growth of around 3X from the original AW size, but after that is should stop growing. I believe this is a bug and will be following up with OLAP development on the issue.
begin DBMS_CUBE.BUILD( 'OLAPCOL3.EXPACT USING (CLEAR VALUES, LOAD, SOLVE)', 'C', -- refresh method false, -- refresh after errors 1, -- parallelism false, -- atomic refresh true, -- automatic order false); -- add dimensions exception when others then rollback; raise;