olapsys.CwM2$LevelDEL
before delete on olapsys.CwM2$Level for each row
Type
BEFORE EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
declare
begin
delete from olapsys.CwM2$AWCubeAggLevel
where IRID in (select cal.IRID
from CwM2$AWCubeAgg ca
,CwM2$AWCubeAggLevel cal
where ca.IRID = cal.CubeAgg_IRID
and ca.Version_ID = 'CWM2'
and cal.Level_IRID = :old.irid);
end;