I am having issues with incremental cube in Transformer. Even though the cube is set to incrementally update every month, it wipes out the previous months data whenever the cube is created and published.Yes the data source will always have a new data every month.
Not sure Whats causing the issue? Any inputs would be appreciated.
Thanks
Hi,
Are you saving the model after each build?
The model needs to be saved for incremental updates.
Probably best to do a time based partition cube if you are not already...?
Cheers,
Ricky
Sorry, I'm stressed so...
i know this is kinda dumb but it happened to me :o
how do you know previous month data is wiped out? probably you are running a report against the updated cube. check the report. it may be filtering for current month only.