Cube Data issue ... in BEx reporting
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 .
Edited by: skarya2003 on May 24, 2011 11:08 PM
It seems like your Count KF is mapped or configured incorrectly. Did you have Count KF in DSO?
If you do not have any Count KF in Cube then just compress cube data at Manage screen then everything will be fine. Thanks!