Cube Problem

I have a cube in which I am putting the data on a regualar basis by running a SSIS package.
I am currently storing my data in partitions of 15 days. I store the datetime upto which I have transferred the data into the cube in a seaprate table and after it I transfer the updated data from my fact table into the cube.E.g Suppose last datetime stored is 15 Aug ,I will transfer the data into the cube from the fact table which has been in the fact table after 15 aug.
But the problem I am facing now is that the newly updated data can contain some of the data of the previous data (of the same datetime)which has been moved to the cube earlier.

So now The problem is want to move only that updated data from the fact table which is not present the cube.
Please help .......any help is welcome....

Hi,

Not to fimilar with this technique, but one way is to process your cube using and incremental update then setup the configuration to only select the records that have been updated.

http://technet.microsoft.com/en-us/library/ms188966.aspx

http://technet.microsoft.com/en-us/library/ms189431.aspx

Hope that helps a bt

Matt

|||Sorry if I misunderstand, but what about SUM() using GROUP BY in your partition select statement? That would sum any duplicates.