olapsys.CwM$DimensionDEL
before delete on olapsys.CWM$DIMENSION 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$AWDimLoad
where Dim_IRID = :old.irid
and Version_ID = 'CWM';
delete from olapsys.CwM2$AWCompSpecMembership
where IRID in (select csm.IRID
from CwM2$AWCompositeSpec cs
,CwM2$AWCompSpecMembership csm
where cs.IRID = csm.CompSpec_IRID
and cs.Version_ID = 'CWM'
and csm.Dim_IRID = :old.irid);
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 = 'CWM'
and cal.Dim_IRID = :old.irid);
end;