SSAS - how to perform partial cube processing without losing data.

(0) Share

Report

Posted on by Komalsahu

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

All responses (1)

Answers (1)

Verified answer

André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: SSAS - how to perform partial cube processing without losing data.

HI Komalsahu,

Can you explain if and how it is related to Microsoft Dynamics AX?