Incremental Cube Refresh on three cases: Insert, Update and delete

[gicy]

Hi guys,
I have done extensive research and yet found nothing sufficent to handle all the three cases (Insert, update and delete on fact table records).

Basically, I have a data mart with the following table.

Fact Table
Time Dimension
Product Dimension

I am creating a package in Frame work manage with these three tables.
I am using this package as a data source to build the cube incrementally.
The fact table has a filter which gives me only the new data.

Please see the snapshot for detailed data flow, steps and example.

It is very surprising that no where cognos transformer guide or other incremental related documentation explains how to handle the updated record or deleted record.

As per my investigation so far, transformer only reads data and when incrementally udpated, it keeps on appending the data to the cube. It does not modify the existing records in the cube.

So, I am of the opinion that:
Incremental refresh only supports addition of new record in the fact table.
For update on fact records or deletion of fact records, we have to re-create a cube.

Please correct me if this is wrong!!
It would be really greateful if some one has acheived incremental refresh handeling all these cases.

[gicy]

I could not attach the image file. Please use this IBM link to see the snapshot.
https://www.ibm.com/developerworks/forums/thread.jspa?threadID=290293&tstart=0