Cube Processing

Hi ,
I have a cube, whose fact table has over 50 million records,
each day the cube is incrementally processed
as I was incrementally updating everyday it was not a problem.
but lately there was some problem while cube was processing
and cube need to be re-processed from scratch as I have lost
all the process data from year 2003.
To process 1 day data it takes around 20 minutes, please let me
know the easiler way to process the complete data from year 2003.
secondly is there anyway i can take the backup and restore it and
later which require no processing of cube and cubes data is intact.
Thanks,
MonTo do individual periods, your best solution is to use partitioning. A
typical design might be yearly partitions for all of history and monthly
partitions in the current year. This allows you to process just a particular
year (for previous years) or individual months in the current year.
On your second question, archive and restore is done at the database level.
If the database was consistent when you backed it up (i.e. no processing was
required); then it will be restored in the same state (i.e. no processing
required).
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mon" <Mon@.discussions.microsoft.com> wrote in message
news:A8E3DEF2-B4FF-4F30-95CE-800D285BB6C0@.microsoft.com...
> Hi ,
> I have a cube, whose fact table has over 50 million records,
> each day the cube is incrementally processed
> as I was incrementally updating everyday it was not a problem.
> but lately there was some problem while cube was processing
> and cube need to be re-processed from scratch as I have lost
> all the process data from year 2003.
> To process 1 day data it takes around 20 minutes, please let me
> know the easiler way to process the complete data from year 2003.
> secondly is there anyway i can take the backup and restore it and
> later which require no processing of cube and cubes data is intact.
> Thanks,
> Mon
>