Editar

Compartilhar via

How to Define BAM Aggregations

  • Artigo

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.

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

  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.

  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