February 7, 2011 at 3:59 am
I have a cube which contains data for two years(2009 and 2010) and a data warehouse containing data for the same period.We are planning to get rid of the 2009 data from DW ,however we still wish to be able to browse the 2009 data on the cube.
Currently i am doing a process update for my dimensions and process full for my measure. once the 2009 data is removed process update on the dimensions will erase the previous data.
Can anyone suggest a proper processing type to be used and how to go about this
Thanks in advance
February 7, 2011 at 7:50 pm
You will need to create partitions in your cube. One for 2009 data and another for the rest.
You will then need to change the way you do your cube processing so that you process the individual partitions instead of the entire cube.
Once you have processed the 2009 partition, you will never process it again and you can purge the data from the source database.
The current cube process task will need to be changed so that it processes the partition containing the data that continues to exist in the source database.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply