Skip to Content
Former Member
Oct 17, 2006 at 03:06 PM

Overwrite feature in Cube


Hi Gurus,

I have an issue with duplicate records, the scenario is as follows,

I have a cube which stores historical data for sales calls made.It is fed by an ODS everyday via a delta load. Now, this cube has a characteristics Category.

The Cube has a record with category "A" , the user changes this category from "A" to "X" in R/3.When the delta is loaded to the cube , this change is added as another record and when we execute the report , the user sees two records for the same calls made. In Actual the user should only see one record with this new category"X".

Is there any way to overwrite the old category with the new category during delta load into the cube ? so that I can see only one record instead of two records.

Thanks in advance...