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 |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2009-10-15 : 14:40:41
|
| hi,i have huge heap (200 mio rows) table for my olap cube. On daily basis heap table grows by 0,5 mio rows; which extends the olap cube daily process and refresh.Since data in heap table change maximum for 6 months in past, i would like to set a partition or a rule that would only process previous 6 months or at least current year (year 2002|2003|2004|2005?|2006|2007|2008|2009); that is only year 2009 and not the whole history.what should I do in Analysis Server 2005 to tell the system to process only desired data and the rest leave untact.thanks. |
|
|
|
|
|
process olap cube