Modifying the size of a nvarchar column of a data item of an activity Applies to: Microsoft BizTalk Server 2004 You have already deployed a BAM definition with a text data item but now you want to change the maximum length of data item. The recommended...

In BizTalk 2006, you can define alerts based on real-time aggregations or scheduled aggregations based on analysis cubes. For aggregated alerts, you have the option to specify a time window. This binds the alerts to be aggregated within a time past to...

The steps to create a report based on data in Bam infrastructure is no different from what one would do for other SQL data sources. It is recommended that you read the “ Creating a Report with Report Designer ” section in SQL Server 2005 Books Online...

BAM introduces a new type of dimension, the Progress Dimension. It allows aggregations of data within categories of progress status of activities. For example, the valid categories of status of a purchase order activity may be evaluating, fulfilling,...

The following applies to BAM in BizTalk 2006. It would work similarly in BizTalk 2004, without SQL NS databases. Deployment and Removal To ensure consistent schema across all BAM databases, run the “Backup BizTalk Server” SQL job for each deployment...

The BAM web service needs to be able to access the SQL NS binaries in order to set up alerts. The following will set up the BAM portal so that you can define alerrts via the portal. Grant Permissions to Microsoft SQL Notification Services bin folder...

The following assumes that you are using Internet Information Services (IIS) 6.0 or higher and your operating system is Microsoft Windows Server 2003. 1. Create Application Pool a. Click Start->Programs->Administrative Tools->Internet Information...

In BizTalk 2006, if you do not want to create a BizTalk group, yet would still like to use BAM. You can create the BAM infrastructure is supported without having to configure BizTalk. The steps are as follows: Define a Bam Configuration file. The...

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...

In BAM, instead of waiting for the execution of data analysis task to update the cube aggregations at scheduled intervals, one can define specific slices of data to be aggregated in real-time. For example, in a departmental store scenario, a store manager...

If you are using the tracking profile editor to map orchestration shapes/events to BAM activity, the date time value that appears in views and cubes will be in UTC (Coordinated Universal Time) time. With a little tweaking of a stored procedure for each...

If an orchestration calls another orchestration multiple times, use relationship to model the process. Examples where this apply may include A purchase order processing with each line item processed by another orchestration. An exception handling orchestration...

Thanks for coming to this blog. I've been active in answering newsgroup questions on Microsoft BizTalk Server; my specialty is in the Business Activity Monitoring (BAM) technology. After some time, I find myself repeating the answers/solutions to similar...