Hi Experts,
In my cube when i do the incremental process its adding
the data double to the existing(without changing the data
in the fact table).But i need the data is to be same when
i do incremental when the fact table data is remain
same.is there any option in the incremental process? can
anybody advise?

if the data appear in double it's because you add data which always exists
in the cube.
The incremental process add new data only without testing you the new data
exists in the cube.
So if you add january sales in a cube with the january sales already filled,
then AS simply add new values without removing old values.

there is some option :
* insure that you add only new data in the cube only once
* full process the partition or cube
* add new data + corrective data for data already present in the cube :

For example, if you want to change the january sales amount to correct the
january value, then send a negative value in the cube and the new value :
Actual january : +10 000$
Corrective value : -10 000$
New value: +15 000$

so AS substract 10 000$ and add 15 000" after.
But this approach is not good for the performance of your cube.
You can do this, but I recommend to done a full process at a regular basis.

To make sure you'll add data only once in a cube, do an incremental process
with you table, then flag the added data in your database, for example, use
a column "added in cube" and set this column to true after the incremental
process.
or move the inserted data to another table (history table) to make sure your
incremental table contain only new data.

"Robert" <anonymous (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news: 64f701c49362$a4485b60$a501280a (AT) phx (DOT) gbl...