TRIGGER: OLAPSYS.CWM2$MEASUREDEL

Source

Description

olapsys.CwM2$MeasureDEL
  before delete on olapsys.CwM2$Measure 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$AWCubeLoadMeasure
      where IRID in (select  clm.IRID
                       from  CwM2$AWCubeLoad cl
                            ,CwM2$AWCubeLoadMeasure clm
                       where cl.IRID          = clm.CubeLoad_IRID
                       and   cl.Version_ID    = 'CWM2'
                       and   clm.Measure_IRID = :old.irid);
  end;