luanne

start c=node:companies(id={id})
match
  c<-[:parent_company*0..]-n
with n
match
  n-[:defines_business_process]->bp-[:has_cycle]->cm
where
  cm.measureDate>={measureStartDate} and cm.measureDate<={measureEndDate}
with cm
match

luanne

start t=node:types(id={id})
match
      (t)<-[:has_type]-(u)<-[:metric_unit]-(ma)<-[:metric_activity]-(m)<-[cm:cycle_metric]-(c)
where
      c.measureDate>={measureStartDate} and c.measureDate <= {measureEndDate}
with distinct m, ma, u, c
match
      (u)<-[:alert_for_unit]-(a)
where
      a.alertDate=c.measureDate and a.fromEntityType={type}