Hi,
I am new to BAM and I do not understand the underlying tables efficiently.
1) For activity there is an AP_ACTIVITY_INSTANCE, EXEC_ACTIVITY_INSTANCE (without aggregation times). Thee there are AP_STARTED and AP_COMPLETED.
What is the difference between them all? which will have what data? Will the instance tables have both started and completed activities?
2) What is with the naming AP_, BAM_, EXEC_? what do they mean? What do EXEC table without time XX suffix mean?
3) Also BAM has various views. What do they mean and when to use which if I plan to create custome aggregation?
Regards,
Anurag