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 data:

• Make sure Integration Services is running
• Run the relevant BAM packages in the Integration Services (e.g., connect to Integration Services using SQL Server Management Studio and find the packages under the stored packages section)