Moving Time Window of BAM Aggregated Alerts

posted by  kevyn (54)  13 months ago (blogs.msdn.com)

In BizTalk 2006, you can define alerts based on real-time aggregations or scheduled aggregations based on analysis cubes. For aggregated alerts, you have the option to specify a time window. This binds the alerts to be aggregated within a time past to the present.

For example: Say there is a purchase order activity, time dimension “Received Time” that has Year, Month and Day as its members. There is also a measure Total Sales. Let’s say you want to define such that if the Total Sales of all purchase orders received for the past 7 days are greater than $1000, you receive an ale