Business analysts use the BAM Microsoft® Excel template to define the events and data to be tracked, along with the logical groupings and aggregations of the tracked data views that users are able to access.
To provide the Excel template to many users, you can upload this spreadsheet to the Business Activity Services Microsoft Windows® SharePoint® Services collaboration site, and set the appropriate permissions for user access. For more information on using the Windows SharePoint Services collaboration site, see the "BAS Collaboration Site" topic in the Information Workers User's Guide. To obtain the user guide, refer to the important note located in Managing Business Activity Monitoring.
Note Business Activity Services must be configured during Microsoft® BizTalk® Server 2004 installation. For more information, see Configuring BizTalk Server.
BAM Excel Macro Requirements
You can run the BAM macros in the BAM Excel template on any computer, whether BizTalk Server 2004 is installed or not. However, the computer must have the binaries listed in the following table installed for the Excel template macros to work.
| DLL name | Version |
|---|
| VBE6.dll | 6.3.91.8 |
| Excel.exe | 10.0.4524.0 |
| stdole2.tlb | 3.50.5014.0 |
| mso.dll | 10.0.4219.0 |
| fm20.dll | 2.1.7017.1 |
| scrrun.dll | 5.6.0.6626 |
| MSCOMCTL.OCX | 6.1.95.45 |
| msado15.dll | 2.71.9030.0 |
| msxml4.dll | 4.0.9406.0 (SP1) |
Note The XML library (msxml4.dll) required for BAM is provided on the BizTalk Server 2004 installation CD. It is located on the CD in the folder \Platform\MSXMLSP1\.
See Also
Troubleshooting Business Activity Monitoring
Managing Business Activity Monitoring
Business Activity Monitoring (BAM)
To download updated BizTalk Server 2004 Help from www.microsoft.com, go to
http://go.microsoft.com/fwlink/?linkid=20616.
Copyright © 2004 Microsoft Corporation.
All rights reserved.