BCS Task execution tracking
I have a question regarding tracking task execution in BI-BCS.
My client has a large structure of more than 100 companies. They all use BCS solution on BI7 to load data, perform reclassifications, validations, balance carry forward, sign-offs, etc... during each reporting cycle.
As time during reporting cycles is crucial, the Group reporting team would like know the progress - they would like to track how many companies executed each task:
- how many loaded data,
- how many run reclasses, etc...
Does BCS have any mechanism to provide these statictics? If not, maybe it's possible to build report (either BEx or ABAP program), but where the tasks statuses are stored? Any idea what's the table name where status of each item from task hierarchy is stored?