E-mail bursting based on a Hierarchy
We've got a requirement to do bursting of data aggregated on different levels of a Profit Center hierarchy. For the lowest level it's quite simple, as the recipient is defined by an attribute of a profit center. But how could we store a recipient email for Sales Area level, which is a hierarchy node? Anybody has met such requirement before?