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
