In BizTalk 2004, in order to add BAM Analysis after an initial configuration without, one can use a command in bm.exe to create the BAM Analysis as well as the BAM Star Schema databases. The star schema database acts us a staging database for the building of the BAM cube. The steps are:
- Modify the BamConfiguration.xml in the \Microsoft BizTalk 2004\Tracking folder. Add the following and type in the server and database names for the star schema and analysis databases.
<DeploymentUnit Name="StarSchemaDatabase">
<Property Name="ServerName"></Property>
<Property Name="DatabaseName"></Property>
</DeploymentUnit>
<DeploymentUnit Name="AnalysisDatabase">
<Property Name="ServerName"></Property>
<Property Name="DatabaseName"></Property>
</DeploymentUnit>
2. Run "bm dbsetup BamConfiguration.xml" from the same folder.
In BizTalk 2006, re-run the BizTalk Server Configuration (Start Menu->Programs->Microsoft BizTalk Server 2006->BizTalk Server Configuration)
