What is the difference between "Full Process" and a "Rebuild" of the OLAP Cubes in Analysis Center? (NETIQKB72999)

  • 7772999
  • 31-May-2011
  • 11-Jan-2012

Environment

NetIQ Analysis Center 2.x
Microsoft SQL Server Analysis Services

Situation

What is the difference between "Full Process" and a "Rebuild" of the OLAP Cubes in Analysis Center?

Resolution

While both a "Full Process" and a "Rebuild" of the OLAP cubes in Microsoft SQL Server Analysis Services will get the same results.  They are each have a distinct way of accomplishing this each with its pros and cons.

  • Full Process - A kind of inplace rebuild of the OLAP cubes.  It makes a copy of an existing OLAP cube and works on the copy.  Since it works on the copy, it is recoverable i.e. (if the current rebuild fails, you can still report from the old one).  But it does require more hard drive space and memory.
  • Rebuild - Deletes everything and then starts from scratch.  This is a much faster process requiring much less space, but if it fails, then you lose all.

Additional Information

Formerly known as NETIQKB72999