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 |
|
Jim77
Constraint Violating Yak Guru
440 Posts |
 Posted - 2007-08-10 : 10:21:37
|
Hi there may someone help me please? I have just started partitioning my sales cubes based on years ie:one partition for 2007one partition for 2006one partition for 2005.etc.etcNow everyday I do a partiti on process automated through DTS for 2007 year,after the previous days sales go into the fact table.This works fine but the thing is all the other years partitons ie 2006 and 2005 go offline and there is no data in them until i process each partition seperatley.Can someone advise me how i can process 2007 without disrupting 2005 and 2006 and keeping this data still available in the cube without reprocessing these one's one at a time please ? |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-08-13 : 09:10:48
|
| Analysis Services SP4 fixed the problem as per the following article :http://support.microsoft.com/kb/297933 |
 |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-08-14 : 08:29:21
|
| Dont know if I am going mad or not but today I tried this process technique through a dts and only one partition processed leaving the historic one unprocessed whereas yesterday when I conducted the same test all worked fine with sp4 in place, very stange ! |
|
|
|
|
|
|
Processing Partitions