Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicklarge
Starting Member
40 Posts |
 Posted - 2012-01-17 : 10:34:07
|
| Hi.I have a cube that takes a number of hours to process if I process from scratch - unprocess followed by ProcessFull. So, I would like to use Process Default to update members where the existing data is updated - that is, column values have changed for some rows; new data may or may not have been added. If I use Process Default the data is not updated, that is, the changed values are not reflected, but any additional data is updated. If I unprocess and do a process full then the data is updated. Is this intended functionality of SSAS, or am I doing this wrong?Regards, Nick. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2012-01-25 : 07:10:13
|
| Have you partitioned your measure groups on the cube?You can partition them based on a calendar member and then you only need to process recent data.EG if you partition the measure group by month you can set your processing task up to only reprocess the last month or 2's data.Duane. |
 |
|
|
|
|
|
Process Default does not update measure data