I have cube where measure groups are partitioned into 2 partition for different time frame as below:
1. latest 2 years data ( PRT_DATA_2YEARS )
2. older data than 2 years ( PRT_DATA_REST )
By processing 1st partition ( with any of processing option ), How can I make sure to process/refresh only last 2 years of data? Meaning only latest 2 years of data will be updated and rest of the data will be intact.
Example: lets say actual data on database got updates for all years. and till now cube has not reflected those changes because it hasn't processed yet. Now we run cube processing job, that will update or fetch updated data only for latest 2 years in the cube. And rest of the data will be intact. There will not be any change in the cube data which is older than 2 years.
Request you to please help to resolve this.
Any suggestions/hints/trick are welcomed.