Symptom
When you try to extract data in BW system, there will be different records for different attempts with same selections in BW system. For example, in same time period and same selection, your try two times, the return record are different and it's not the correct number either.
HINTS
- Try to perform the extraction from Visual Composer to compare the result. You can model a VC model and use the same datasource for same period to see if the record is correct.
- Recreate Infopackage in BW system, usually Infopackage holds the connection in memory, if there is any changes in source System (BPM), it will not reflect in BW system. Recreate will ensure the connection is correct.