Just a post to help those newbies to BAM, like me, out there in regards to an issue I encountered getting my OLAP cubes to display data. The BizTalk 2006 R2 documentation describing getting BAM to work is based on using a SQL Server 2000 database, and in particular DTS. In an environment using SQL Server 2005, DTS is not used, but Integration Services. So if you encounter a situation where you are successfully adding to BAM (re., the primary import database), but your aggregation views are not displaying...
The amount of traces generated by WCF (System.ServiceModel and System.ServiceModel.Message... can be overwhelming at first glance. Here is a short post about some the features. A more detailed description can be viewed at MSDN Service Trace Viewer