January 20, 2020 at 3:31 am
Hi All,
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.
Regards
January 21, 2020 at 4:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 31, 2020 at 7:59 am
You don't mention whether you are using Tabular or Multidimensional - it's different in each case.
If it's multidimensional, based on what you are saying, the pattern would be 1. Process Update of dimensions, 2. Process Data of your 2 years' partition, 3. Process Index of the full cube.
If it is tabular the pattern is different. Have a look into the following: https://www.sqlbi.com/articles/using-process-add-in-tabular-models/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply