We're loading our Opportunity planning data of CRM in a transactional cube in BW side. Later this transactional cube data is then uploaded into a standard cube.
For an opportunity, user enter some planning data for a given product (A). which was duly stored in transactional and then later in the standard cube. Then user deleted the product (A) and entered a new product (B) on CRM side. However in the transactional cube, records for the previous product (A) also exist and the same flows to the standard cube as well.
Fyi, delta load mechanism is in place for loading of both types of cubes.
Could someone throw some light why the old item (product A) is still there in the cubes. coz this gives a wrong picture in the report, though the key figures for product A are 0.