How to Define BAM Aggregations

BAM supports two types of data aggregation:

• Online analytical processing (OLAP) aggregations

• Real-time aggregations (RTA)

  BAM uses Microsoft SQL Server Analysis Services to implement OLAP aggregations.

  You must configure the triggers on the BAM Primary Import database that define RTA.

To define OLAP aggregations

1. In the BAM Excel workbook, create a view, add at least one dimension and one measure to the PivotTable report, clear the RTA toolbar button, and then save the workbook.

   • For information about opening the BAM workbook, creating a view, and adding dimensions and measures, see Defining a BAM View.

2. Deploy the workbook.

   • To deploy the workbook, follow the instructions in How to Deploy BAM Definitions.

3. A solutions developer uses the DirectEventStream class to import events into the BAM Primary Import database.

   • For information about the DirectEventStream class, see DirectEventStream Class.

4. Run the update cube Data Transformation Services (DTS) package.

   • For information about running the update cube DTS package, see BAM DTS Packages.

5. Open the most recent live data copy of the workbook to see the OLAP aggregations.

   Important

   For security reasons, BAM does not delete existing live data copies of the workbook. Instead, BAM increments the file name of the live data copy.

To define the RTA

1. In the BAM Excel workbook, create a view, add at least one dimension and one measure to the PivotTable report, select the RTA toolbar button, and then save the workbook.

   Warning

   Do not define multiple RTAs that use the same BAM activity. If you do so, the RTA data will be incorrect when you archive the BAM data.

   • For information about opening the BAM workbook, creating a view, and adding dimensions and measures, see "Defining a Business Activity View" and "Defining Aggregations" in the Information Workers User Guide.

2. Deploy the workbook.

   • To deploy the workbook, follow the instructions in How to Deploy BAM Definitions.

3. A solutions developer uses the DirectEventStream class to import events into the BAM Primary Import database.

4. Open the most recent live data copy of the workbook to see the RTAs.

   Important

   For security reasons, BAM does not delete existing live data copies of the workbook. Instead, BAM increments the file name of the live data copy.

See Also

BAM DTS Packages
How to Deploy BAM Definitions
Updating OLAP and RTA Connection String Properties
Managing the BAM Dynamic Infrastructure