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)
Fri, Sep 21 2007 12:31 PM