I'm a beginner in SAP BW and I have a problem with my SAP instance. Some of the data disappears on reports after loading.
My report uses the source table /BIC/TABX.
Loading data into this table looks like (delta loading):
data from several sources are loaded into the table:
- ODSO Y1 -> my report ODSO X (/BIC/TABX) (after filtering data from ODSO X)
- RSDS Y2 -> my report ODSO X (/BIC/TABX) from flat xls files
In the morning, data was manually loaded. There were 100,000+ records in the target table / BIC / TABX after loading.
There was probably another load during the night (possibly by job) and the number of records after that load has decreased to 4499.
Anyone have any idea what could be causing the data reduction?
I would like to add that after the first charge where there were 100,000 + records, I missed the data from the current month, after overnight loading, some part of the data for the previous months are missing, while for the current month there are many more data.