i am loading data in a PsA -> ODS - > Cube Delta reacord are filling daily .
1st Day - > one record is moved to cube
2nd Day same record is updated in R/3 ( There is a change in status field of that record )
records loaded to BI , in ODS it overwrite the exitsing previous record & update with New one -- Correct
Cube ; it makes 3 records 20 ( old ) , -20 ( New ) , +50 ( New update value ) . - Correct .
BUt when i am Displaying the data in BEx query - it shows me count = 3 record 20,-20,50 ( Incorrect )
From my view it has to show only Update entry ( 50 ) i.e count = 1 ( No of records) .
Pl suggest .
Thanks Regards
Sanjeev Kumar
Edited by: skarya2003 on May 24, 2011 11:08 PM