Skip to Content
0
Former Member
May 24, 2011 at 08:56 PM

Cube Data issue ... in BEx reporting

74 Views

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