How to do incremental update

[Sarayucog]

Hi all,

I have a cube currently its a daily schedule and its refreshing as full refresh means daily its reading the data from the scratch because of this its taking lot time to fetch data. So now I want to make that cube as incrementally update daily.

I know that in cube properties in processing tab we have a check box like incremental update. With this option also its reading full data.

If we need to make any changes where is that.

Please tell me how to do the incremental update of a cube. its very urgent.

I need the process how to do. If you have time please give the detailed answer.


Thanks in advance
Sarayu

[tiomelenas]

Hi Sarayucog,

if you check the option "incremental update", you have to filter the datasource by the cube generation period (in your case, daily).

The cube generation should only read the new period (read 1 day of information per execution).

In other case, generated cube data, would be duplicated in the previous days of execution.

Regards.
Tiomelenas

[Sarayucog]

Hi,

Thankyou for you information, but that is not solve my problem.

Already I know that, but its not working with that only option. I think somewhere in IQD we have to change. I changed that but its working sometimes and sometimes not.

I don't know what it is exactly.



Thanks
Sarayu