Defining real-time aggregations with BizTalk Server 2009 / Excel 2007

If you're using Excel 2007 to define your BAM activities and views, you may up spending some time trying to figure out what happened to the "mark pivot table as real time aggregation (RTA)" button. It's there, but unless you're used to working with it, it can be a little subtle to notice. At the time this was written, the relevant documentation only shows an Office 2003 screen shot, so I thought I'd do a post.

In the toolbar, press the Add-in button, and you'll see what's shown below. The arrow is pointing at the RTA button, and it is pressed in this screen shot, indicating the pivot table is RTA.



And, along those same lines, if you're not seeing the BAM add-in, then press the top-left Office button, choose "Excel options", then and use "manage add-ins" to add it:


PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>