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)