How does BAM aggregation works

xiaolong974

Hi,

We are using xCP2.1 and having difficulties to understand how does the BAM works

I need to report the number of invoice by status (paid, not paid) and by country.

Therefore I designed a BAM report with the column: Status | Country | count(r_obect_id of invoice object)

Using an DQL such as: "select count(r_objectid) from invoice where status='paid' and country = 'EN'" I have 300 records

Looking at the BAM results, I have several lines :

Paid | EN | 100

Paid | EN | 100

Paid | EN | 100

I was expecting only one line:

Paid | EN | 300

When BAM aggregates data (by default every 5mn?), does it aggregate only new data based from the last aggregation ?

If yes, if I have 3 lines, does it means every 5mn I got 100 new invoices with status "paid" in country "EN" ?

Thank a lot for any light on how the BAM Works